Link to home
Create AccountLog in
Avatar of tomrector
tomrectorFlag for United States of America

asked on

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
ASKER CERTIFIED SOLUTION
Avatar of Saqib Husain
Saqib Husain
Flag of Pakistan image

Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
Avatar of tomrector

ASKER

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
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.