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
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
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.
ASKER
I attached a revised sample to make it more clear.
sample-row.xlsx