Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
combining multiple rows into one row
Can anyone help with this issue? I have a spreadsheet with 3 rows of
data that I need to put on one row, then skip down 4 rows and pull the next 3 rows of data into one row. Finally, I need all the rows together, without blank rows between them. The 3 rows are set up like this: Row 1 - data in cells A - D Row 2 - data in cells A - K Row 3 - data in cells A - I I need the data from the 3 rows put into 1 row - cells A - X. The next set of data is 4 rows down. For example: the 1st set of data begins on row 1, the next set on row 5, the next on row 9. I need the program to repeat until all the data on the sheet is modified. If anyone can help, I would really appreciate it. *** Sent via Developersdex http://www.developersdex.com *** |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
combining multiple rows into one row
Thank you, I was able to get everything working with your help.
*** Sent via Developersdex http://www.developersdex.com *** |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Combining multiple rows | New Users to Excel | |||
Combining data from multiple rows | Excel Discussion (Misc queries) | |||
Combining same data in multiple rows | Excel Discussion (Misc queries) | |||
Combining multiple rows to one | Excel Programming | |||
Combining data from multiple rows | Excel Programming |