Combining cells with the same data but keeping some data separate

[jarrodexcel]

Good afternoon all.

Have a tricky goal to try and combine two rows with the same data, so merge it into one row of data. I will need a formula that can combine them as ill have lots of this data coming in.

As you can see below - A, B and C all share the same data and i need them merged into one, but D has different data and would need that to multiply by each other so the 5xABC etc and 3x ABC becomes 8xABC1111-1999.

Any help will go a long way !

Thank you so much


A B C D

John Doe	125522​	The big tree hotel, abc london	5xABC1111-1999
John Doe	125522​	The big tree hotel, abc london	3xABC1111-1999

 

[jarrodexcel]

Oh sorry my bad !

Please see below the new cells that are added in

Thank you

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		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

 

[jarrodexcel]

I think that does need some visual clarification @jarrodexcel

Oh sorry my bad !

Please see below the new cells that are added in

Thank you

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		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

 

[JvdV]

Im not sure what you want to do when you group by 'The Ark' for example. What if both rows had a different value etc?

 

[jarrodexcel]

Im not sure what you want to do when you group by 'The Ark' for example. What if both rows had a different value etc?

Good morning! So for grouping as such for the new row, if they are able to combine all text as well, same as the the 2xabc etc row that would be a miracle for me !

 

[jarrodexcel]

Good morning! So for grouping as such for the new row, if they are able to combine all text as well, same as the the 2xabc etc row that would be a miracle for me !

For more clear reference of what i am after to hopefully clear up any confusion.



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]

Cross-posting (posting the same question in more than one forum) is not against our rules, but the method of doing so is covered by #13 of the Forum Rules.

Be sure to follow & read the link at the end of the rule too!

Cross posted at: Combining cells with the same data but keeping some data separate
There is no need to repeat the link(s) provided above but if you have posted the question at other places, please provide links to those as well.

If you do cross-post in the future and also provide links, then there shouldn’t be a problem.

 

[jarrodexcel]

Cross-posting (posting the same question in more than one forum) is not against our rules, but the method of doing so is covered by #13 of the Forum Rules.

Be sure to follow & read the link at the end of the rule too!

Cross posted at: Combining cells with the same data but keeping some data separate
There is no need to repeat the link(s) provided above but if you have posted the question at other places, please provide links to those as well.

If you do cross-post in the future and also provide links, then there shouldn’t be a problem.

apologies ! This is my bad, i will read up on the rules fully now before posting again !