I need help performing a complicated transpose

Question

I have a list of items in a column, i need to transpose them to horizontal. I need a1 in b1 and a2 in c1 and a3 in d1, then a4 in b2 and a5 in c2 and a6 in d2 and so forth.

I think you can use Power Query and add a column with list 1,2,3,1,2,3... then translate to row. — Lee, Aug 25 '20 at 09:32

score 4 · Answer 1 · edited Aug 19 '20 at 16:52

4

If your version of Excel supports dynamic arrays, you can use this in cell C2:

=INDEX($A$2:$A$10,SEQUENCE(3,3))

The call to SEQUENCE creates a 3x3 grid of integers. Using this as the row parameter of index causes the correct value to be returned from the list of colors.

edited Aug 19 '20 at 16:52

Reddy Lutonadio

17,120
4
14
35

answered Aug 19 '20 at 15:54

FlexYourData

6,430
2
6
21

+1 Simple and very effective – Reddy Lutonadio Aug 19 '20 at 16:54

I need help performing a complicated transpose

1 Answers1