Change Table Orientation

[saachitalwar]

I have date in the form:

h2	h1	CCY	value	abs value
heading 2	heading 1	EUR	-3453645646	38397274
heading 2	heading 1	GBP	-34536	10361623
heading 2	heading 1	CHF	8756453	1105099
heading 2	heading 1	SEK	0	0
heading 2	heading 1	AUD	-2104385.8	2104386
heading 2	heading 1	JPY	-3097780.03	3097780
heading 2	heading 1	USD	55327648.31	55327648
heading 2	heading 1	DKK	0	0

and need to convert it to the form:

CCY	value	abs value
heading 1
heading 2
EUR	-3.5E+09	38397274
GBP	-34536	10361623
CHF	8756453	1105099
SEK	0	0
AUD	-2104386	2104386
JPY	-3097780	3097780
USD	55327648	55327648
DKK	0	0
JPY	-3097780	3097780
USD	55327648	55327648
DKK	0	0

[cjaneczko]

Looks like all you are looking to do is put the headings above the data. You can transpose the first two fields, find the unique values and then Union them back into the original dataset. 

[Brando]

Hey @saachitalwar 

Here's my attempt at solving your problem, it's not super graceful but gets the job done!

[aatalai]

@saachitalwar take a look at this