Converting Columnnar data into rows

[Purpose]

Hi
I have a four column data set as follows:

Account USCO US OUS
100          1       4       7
150          2       5       8
200         3        6       9

I will need to convert it into below two columns data set 

Account          Amount
100-USCO       1
150-USCO     2
200-USCO      3
100-US           4
150-US           5
200-US          6
100-OUS       7
150-OUS       8
200-OUS       9

I have used three different connectors and used formula tool to come up with new Amount column and values for the account column. Then I used the union tool to combine the three outputs into a single output. The 3 column headers (USCO, US and OUS) are constant.

I am wondering if there is a better way to accomplish this in Alteryx. Any ideas are greatly appreciated.

Purpose G.

[ponraj · Accepted solution]

Here is my sample workflow. 

[Purpose]

Ponraj,

Great!.  I like your solution. It is simple and efficient.  Thanks a lot.  They is resolved now. 

Purpose