Consoldate Mulitple Rows into a Single Row

[madams1260]

Hi-

Is there any chance someone knows how to combine multiple rows into a single row. Some of the column cells would be duplicate data, in those cases that value would result. In the cases where that does not occur, the new unique value should be displayed in a new column within the same row.

IE:

Orig Data

[A/N] [Type] [Name] [Bene] [Bene Type] [%]
123 IRA Smith Max Primary 100
123 IRA Smith Tom Contingent 50
123 IRA Smith Sue Contingent 50

Reformatted Data

[A/N] [Type] [Name] [Bene] [Bene Type] [%] [Bene] [Bene Type] [%] [Bene] [Bene Type] [%]
123 IRA Smith Max Primary 100 Tom Contingent 50 Sue Contingent 50



Thank you in advance for any help on this!

[alansidman]

Please read the yellow banner at the top of this page on how to attach a file.

[madams1260]

See Attached. Thanks

[kvsrinivasamurthy]

In A12

Please Login or Register  to view this content.

In B12 , up to columnC

Please Login or Register  to view this content.

In D12 then up to last column

Please Login or Register  to view this content.

[madams1260]

I'm about halfway there I would say. I was able consolidate the first three rows starting with 22 into row 32. That worked great.

I was not able to drag the formula to consolidate further down.

I added a "New Data Set" and my attempt in the sheet.

To accomplish my goal, the sheet would have 124 in A33 along with all the consolidated data from A/N 124. In this case the 2 rows, then it would move to 125 etc.

See update...

Really appreciate your help!

[kvsrinivasamurthy]

In entering the ranges in formulas there were mistakes.
I have corrected them
Pl see file .