Converting column headers into rows to create unique rows

[flying_cpa]

Hello all -

I'm trying to create unique rows based off data that is organized as account by business unit. What I'd like to have Alteryx do is convert this into a three column table in which each account and business unit are combined to create a unique row. 

I'm confident this is an elementary question; looking forward to learning more about Alteryx as a result! 

What I have: 

	Company Code	Company Code	Company Code	Company Code
Account	100	101	102	103
1	25	68	111	154
2	62	105	148	191
3	76	119	162	205
4	3	46	89	132
5	37	80	123	166

What I would like: 

Account	Company Code	Balance
1	100	25
1	101	68
1	102	111
1	103	154
2	100	62
2	101	105
2	102	148
2	103	191

                                      etc...

Thanks so much. 

[JohnJPS · Accepted solution]

Hi @flying_cpa,

You should be able to Dyanmic Rename to move that row into the column headers, then Transpose to get what you want.

I've attached an example.

Hope that helps!

 - John

[flying_cpa]

Thank you, @JohnJPS!!