I have an Excel table which displays 2 entities. Because Entity A contains multiple Entity B, I have one row for each combination of A and B, in a cartesian product.

What I need is to transform this table in such a way that the columns from Entity A will be distinct, and I need to concatenate the values of Entity B.


Here we got 2 tables, the first one is my original. On the second one, the first few rows are grouped/concatenated exactly like I need it.


What is the best way to achieve this grouping/concatenation?

  • Excel 2016 CONCAT would be the solution for you, unfortunately previous verdict doesn't have it. You can still achieve it concatenating the values in a helper column. – Máté Juhász Aug 11 '16 at 18:33
  • @MátéJuhász, thanks! Do you mean creating another column for the concatenated values? – andrerpena Aug 11 '16 at 18:36
  • @MátéJuhász I have Office 2016, so, if you know a solution, please. Thank you. – andrerpena Aug 11 '16 at 19:04

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.