Home |
Search |
Today's Posts |
#1
|
|||
|
|||
combining row information
I'm having an issue with an easy way to combine row information. Below is an example of the both the data and what I would like as an end result. The spreadsheet I have contains over 37000 lines. column a column b column c column d 1234 glove ea 04661 1234 glove ea 01661 1234 glove ea 06661 1235 mask ea 04661 1235 mask ea 01661 The output I would like would be column a column b column c column d column e column f 1234 glove ea 04661 01661 06661 1235 mask ea 04661 01661 -- tgoosed ------------------------------------------------------------------------ tgoosed's Profile: http://www.excelforum.com/member.php...o&userid=28088 View this thread: http://www.excelforum.com/showthread...hreadid=475929 |
#2
|
|||
|
|||
Here's a macro to do it
Sub Test() Dim iLastRow As Long Dim i As Long Dim rng As Range iLastRow = Cells(Rows.Count, "A").End(xlUp).Row For i = iLastRow To 2 Step -1 If Cells(i, "A").Value = Cells(i - 1, "A").Value Then Cells(i, "D").Resize(, 252).Copy Cells(i - 1, "E") If rng Is Nothing Then Set rng = Rows(i) Else Set rng = Union(rng, Rows(i)) End If End If Next i If Not rng Is Nothing Then rng.Delete End Sub -- HTH Bob Phillips (remove nothere from email address if mailing direct) "tgoosed" wrote in message ... I'm having an issue with an easy way to combine row information. Below is an example of the both the data and what I would like as an end result. The spreadsheet I have contains over 37000 lines. column a column b column c column d 1234 glove ea 04661 1234 glove ea 01661 1234 glove ea 06661 1235 mask ea 04661 1235 mask ea 01661 The output I would like would be column a column b column c column d column e column f 1234 glove ea 04661 01661 06661 1235 mask ea 04661 01661 -- tgoosed ------------------------------------------------------------------------ tgoosed's Profile: http://www.excelforum.com/member.php...o&userid=28088 View this thread: http://www.excelforum.com/showthread...hreadid=475929 |
#3
|
|||
|
|||
Bob, Thank you!!! That worked perfectly and save me hours of work. -- tgoosed ------------------------------------------------------------------------ tgoosed's Profile: http://www.excelforum.com/member.php...o&userid=28088 View this thread: http://www.excelforum.com/showthread...hreadid=475929 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Illinois Personal Information Protection Act | Excel Worksheet Functions | |||
Combining cell information | Excel Worksheet Functions | |||
Update a spreadsheet with new information. | Excel Discussion (Misc queries) | |||
Clearing information in certain columns | Excel Discussion (Misc queries) | |||
Combining Information in a Bar Chart | Charts and Charting in Excel |