Change Table Orientation

Question

I have date in the form:

h2h1CCYvalueabs valueheading 2heading 1EUR-345364564638397274heading 2heading 1GBP-3453610361623heading 2heading 1CHF87564531105099heading 2heading 1SEK00heading 2heading 1AUD-2104385.82104386heading 2heading 1JPY-3097780.033097780heading 2heading 1USD55327648.3155327648heading 2heading 1DKK00

and need to convert it to the form:

CCYvalueabs valueheading 1 heading 2 EUR-3.5E+0938397274GBP-3453610361623CHF87564531105099SEK00AUD-21043862104386JPY-30977803097780USD5532764855327648DKK00JPY-30977803097780USD5532764855327648DKK00

aatalai · Answer

@saachitalwar take a look at this

Change Table Orientation.yxmd

Brando · Answer

Hey @saachitalwar

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

Change Table Orientation.yxzp

cjaneczko · Answer

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.