Convert column headers to actual data in column (not a transpose issue)

[Lmreif20]

I have a sheet with downloaded data that looks like this:

Name	4102	4103	1135
Doe, John	600	2499.02	3099.02
Doe, Jane	600	2501.20	3101.20

I would like to convert it to look like this:

Name	Code	Dollars
Doe, John	4102	600
Doe, John	4103	2499.02
Doe, John	1135	3099.02
Doe, Jane	4102	600
Doe, Jane	4103	2501.20
Doe, Jane	1135	31101.20

Is this possible? thank you.

 

[DRSteele]

That's simple in PowerQuery, with one step required: select Name and unpivot other columns.

 

[Lmreif20]

That's simple in PowerQuery, with one step required: select Name and unpivot other columns.

Thank you! That worked beautifully.

 

[DRSteele]

You're welcome!