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 |
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.
Hey @saachitalwar
Here's my attempt at solving your problem, it's not super graceful but gets the job done!
@saachitalwar take a look at this