Forum Discussion
Solved
Anything in Excel that would put the attached into three columns
I want the list below to be put in a format like the top three (without the gaps)
Hi,
This is a common Excel problem where we need to Unstack records (rows ► columns)
You watch 4 different ways to do that:
https://www.youtube.com/watch?v=LzEGcRWEmRw
Hope that helpsNabil Mourad
A simple lookup by index should do the job. Given an index column 'k' for the output table and naming the 2-column input table 'data', the formula
= INDEX(data, {1,2,1} + 2*(k-1), {1,1,2})
would return the data in the layout required.
PeterBartholomew1 The attached S/S with the formula =MOD(ROW()-1,3) does all what I wanted. Thanks for your input. Merry Christmas.
