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?
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.
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.
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.
Velouria, many thanks for that!
