Combining Cells/Rows and Adding values

[jarrodexcel]

Good afternoon all, I have tricky request here and hoping someone can help with it.



As you can see the first column depicts the Individual in charge of each account - John DOE.
Then the account number, account name, unit type and finally product code.

I need a formula that can combine all of these together if there is multiple lines with the same account

SO the office stop is fine as it is and requires no change, but accounts with multiple products and units these need to be combines into one row.

For example.

The Ark i need its end product to look like this in the row

John DOE

1245222

The Ark

1x white tree + 3x blue sheet + 1x Green Tray

5xABC1234-9999

Data that is sent to me that needs formatting

John DOE	1255887	The office stop		2xABC1234-40004
John DOE	1234466	Two tree style shop		2xABC1111-4004
John DOE	1255442	Viewing Galary	1 x Green Tray	5x1155-1234tt
John DOE	1245222	The Ark	1x white tree	3xABC1234-9999
John DOE	1245222	The Ark	3x blue sheet + 1x Green Tray	2x1234-9999_SS
John DOE	5222369	Park Plaza		7xABC1235-1994
John DOE	5478116	Orange floor shop		3xC111_2_4-SS
John DOE	5544899	The top stop	1x Green Tray + 2x White Tree	1xABC4004-1234
John DOE	1234455	The big tree hotel, abc london		6xABC1155-9999
John DOE	1234455	The big tree hotel, abc london		2xABC1155-9999

Any Help will be welcomed. Thank you

 

[Fluff]

Duplicate to: Combining cells with the same data but keeping some data separate

In future, please do not post the same question multiple times. Per Forum Rules (#12), posts of a duplicate nature will be locked or deleted.

In relation to your question here, I have closed this thread so please continue in the linked thread.