excel question

I have a 1 column Excel file with logical groupings of 5 records per group.  I want to "rotate" the data, 5 records at a time, and end up with 5 column Excel file.

If there an easy Excel way to do this?   I think SQL has a way to rotate data.
LVL 1
HLRosenbergerAsked:
Who is Participating?
 
Saqib Husain, SyedConnect With a Mentor EngineerCommented:
If your data starts in cell A1 then enter this formula in C1

=INDEX($A:$A,ROW($A$1)-1+COLUMN()-COLUMN($C$1)+1+5*(ROW()-ROW($C$1)),1)

and copy it down and across
0
 
SteveCommented:
If the data is in a data table you can use a CROSSTAB query to restructure your result.
0
 
HLRosenbergerAuthor Commented:
thanks
0
All Courses

From novice to tech pro — start learning today.