How to combine several Rows in excel into a single row.

**Vadimchik** · 05-29-2012, 07:26 AM

Hi Everyone,
I hope you can help me out.
I need to combine several Rows in excel into a single row.
Right now there are Client Numbers Which appear twice or even three times when the field "Current Prov" changed or "Broad change" changed, or both.
I need to have the history of every client in one row like the following:Client number---Change Date1----Change Date2--Change Date3----Combination-Previous1---Combination Previous2-----Combination Previous3-----Prev Prov1--Prev Prov2---Current Prov---Broad Change1---Broad Change2---Broad Change 3------ Broad Description

Its a bit complicated.. tried running a VBA script...
Didnt have much luck.
All I was able to do with it is to delete every similar line exept the first one (of the same client).

Can you guys help?

Thanks (:

**arlu1201** · 05-29-2012, 07:28 AM

It will be good if you upload a sample sheet. Ensure that it is in the same format as the original.

**Vadimchik** · 05-29-2012, 08:16 AM

Sure.
Thanks for the reply

**arlu1201** · 06-04-2012, 07:21 AM

Can you provide an output sheet to show us how you want the data to be displayed? Atleast 1 or 2 rows of data will be good.

**Vadimchik** · 06-06-2012, 03:39 AM

Thanks for the help Arlette,
I acctually looked at it from another angle and I think I have a way,
I inserted another post, maybe you'll be able to help me.
If you look at my latest post you'll see it.

Thanks !