Log In
Register
Home
May 17, 2019
Offline
I have an output that puts the (15) data fields in sequential order, repeating every 15 rows in a single column. I can't find a way for PQ to handle this and am rather surprised as this is not an uncommon problem. I can do it via an index formula in excel but would prefer the once done - always works automatically PQ approach. Is this possible, am I missing/overlooking something?
See Answer
November 8, 2013
Offline
Hi Trevor,
You have to be more precise, "I can't find a way for PQ to handle this[..]" is not saying anything about the structure of the desired output.
Please clarify.
May 17, 2019
Offline
Yes, sorry, the 15 repeating data items need to be transposed to a row of 15 columns to create a usable data table. See attached file.
Trusted Members
Moderators
November 1, 2018
Offline
You could add an Index column starting at 1. Then add a calculated column using the index column thus:
Number.Mod([Index]-1,15)+1)
which will return numbers 1 - 15 repeatedly, then pivot on this new column.
Answers Post
1 Guest(s)
