Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Combining Multiple Rows of Data in Excel
Hi,
I am currently using Office 2007 and in my spreadsheet I have 18162 Rows of Data. (starting at A3 and going to M18162) Column A is the only constant, which contains customer numbers which has each customer number appearing twice. I would like to combine the 2 rows as 1. However some customers are not repeated. This is my example. (This is what I have) A B C D E F 12 1 2 13 3 4 16 5 6 12 10 15 13 13 10 21 31 16 10 22 32 17 11 12 14 23 33 (This is what I would want) A B C D E F 12 1 2 10 15 13 13 3 4 10 21 31 16 5 6 10 22 32 17 11 12 14 32 33 I have tried writing a few macros, but I can only delete the extra row or move the data, not both, which is what i am trying to accomplish. My skill are very limited so any help is greatly appricated. Thanks" |
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 data from multiple rows | Excel Programming | |||
combining multiple rows of data into one single row of data | Excel Worksheet Functions |