Combine 2 columns and group values into one column

[ashishshetty]

Hello!

Beginner user, not sure if this question has already been answered. I am looking to combine 2 columns to get a single column, but with single grouped value of column 1 repeated only once.

For example:

Input:

Output:

Attached is a sample excel input.

Appreciate the help! Thank you!

[jdunkerley79 · Accepted solution]

I'd suggest:

Start by using a summarise tool to concatenate all the values in Column2 to a single string for each Column1 separated by columns

Then you can use a formula tool to add Column1 value in front of the concatenated values

Finally a text to columns tool will break it up into the rows you need.

Sample attached

[ashishshetty]

Thank you very much!

[BaDaBoom]

I used your solution to solve the opposite problem.

Thank you very much !!!!