I got this stupid file where every three columns should be converted to rows, the end result should be three columns, Agreement/Invoice number/Invoice date.
I guess its an easy solution, but I'm stuck 
Pivot or unpivot?
Both 
Do unpivot first. Then modify the labels - remove the numbers from lables, so you only have three labels:
- Agreement
- Invoice number
- Invoice date
Put the removed number in a separate column.
Then do pivot with grouping by the column with numbers (the numbers will become rows).
Tried but does not get correct result, I should have columns as you write Agreement, Invoice number and Invoice date but cant figure it out.
Attached the files if anyone wants to try.
Faktura ikke overført OS.morph (58.6 KB)
Kundefakturaer ikke synket til Xledger.xlsx (97.2 KB)
Please try this one.
Faktura ikke overført OS.morph (67.1 KB)
2 Likes
Perfect, thanks!
Det var så lidt.