Thread
:
Macro to combine 'like' rows
View Single Post
#
2
Posted to microsoft.public.excel.misc
Dave Peterson
external usenet poster
Posts: 35,218
Macro to combine 'like' rows
You have a response at your other post.
wrote:
I have data where the first column has like data and the second column
has unique data such as below:
1234 BBB
1234 ZZZ
9999 ALL
5431 JJJ
5431 LLL
I've been trying to figure out a macro or anything really to combine
the like rows and delete the old ones. For example the ouput would
look like this:
1234 BBB ZZZ
9999 ALL
5431 JJJ LLL
Thanks!
- Tek
--
Dave Peterson
Reply With Quote
Dave Peterson
View Public Profile
Find all posts by Dave Peterson