How to rearrange data?

[gc-804]

Hello,

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

Box Number	Description 1	Description 2	Description 3	Description 4
20	ABC		DEF
44		CCC
46	AAA			BBB
52		FFF	EEE

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 Number	Description
20	ABC
20	DEF
44	CCC
46	AAA
46	BBB
52	EEE
52	FFF

Thanks!

[fmvizcaino · Accepted solution]

Hi @gc-804 ,

Attached is a solution showing how to do it.

Let me know if you need further assistance.

Best,

Fernando Vizcaino

[gc-804]

@ fmvizcaino,

Thank you so much for your prompt assistance!!