Combine 2 columns and group values into one column

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!

Sample Set.xlsx

Tips and Tricks

Common Use Cases

Best Practices

Transformation

Preparation

Accepted answers

jdunkerley79

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

Transform to 1 column.yxmd

All comments

jdunkerley79

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

Transform to 1 column.yxmd

ashishshetty

Thank you very much!

BaDaBoom

I used your solution to solve the opposite problem.

Thank you very much !!!!

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703