How to rearrange data?

Question

Hello,

I have 10 columns with headers Description 1 to 10. This is a small sample for example purpose:

Box NumberDescription 1Description 2Description 3Description 420ABC DEF 44 CCC  46AAA  BBB52 FFFEEE

How to combine the multiple descriptions in the same row that have the same box number into one column with a new header "Description" while maintaining the box number in the Box Number column like the output below?

Box NumberDescription20ABC20DEF44CCC46AAA46BBB52EEE52FFF

Thanks!

fmvizcaino · Accepted Answer

Hi @gc-804 ,

Attached is a solution showing how to do it.

Let me know if you need further assistance.

Best,

Fernando Vizcaino