Combine rows

I have a spreadsheet 6000 thousand lines long,  1st row A to G is header names, rows  2-6 is data.   (no math/no formulas).
I want to move data in rows 3,4,5,6  to row 2 starting at column/cell H2 , then delete  3,4,5,6  and do it again (until end of sheet)

Sample attached with  "as is"  and desired.
sample-row.xlsx
tomrectorAsked:
Who is Participating?
 
Saqib Husain, SyedConnect With a Mentor EngineerCommented:
On a new sheet enter this formula in A1

=INDEX(Sheet1!$A:$G,IF(ROW()=1,1,(ROW()-2)*5+2+INT((COLUMN()-1)/7)),MOD(COLUMN()-1,7)+1)

and copy it across to column AI and down as far as needed.
0
 
tomrectorAuthor Commented:
Maybe ,, but how does this create row 3 from next set of 5 and then row 4 from the next set of 5, etc, etc, etc.

I attached a revised sample to make it more clear.
sample-row.xlsx
0
 
tomrectorAuthor Commented:
Disregard previous email,  It does work!  Thank you very much for the answer.  After copying down 1200 rows cols A:AL   it pulls the right data.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.