Table Format

[EmilAlteryx01]

Hi,

My current table is structured as follows:

Record	F1	DailyCalc	F3	F4	Type
1	[Null]	USD	EUR	GBP	Internal
2	Interest Collections	500000.5	105000.8	165000	Internal
3	Principal Collections	385125000	840000.6	8955000.5	Internal

 How do i get it to read as below, 

Record	Cash Account	Amount	Type
1	USD Principal Collection	385125000	Internal
2	USD Interest Collection	500000.5	Internal
3	EUR Principal Collection	840000.6	Internal
4	EUR Interest Collection	105000.8	Internal
5	GBP Principal Collection	8955000.5	Internal
6	GBP Interest Collection	165000	Internal

[binuacs]

@EmilAlteryx01 one way of doing this

[EmilAlteryx01]

is it possible to provide this in a workflow format

[binuacs]

@EmilAlteryx01 workflow attached

[EmilAlteryx01]

This solution worked.. Thanks @binuacs