Forum Discussion
Transposing data from excel
I have a problem with a very difficult dataset. This dataset has year written over 4 columns and all the values are therefore written after as four different columns. (See Screenshot) "Nyeste år" = ...
Hi, it is possible, but you have to provide sample data in usable format - not as a screenshot (if you don't know how - read my note below this post) and also expected result based on sample data.
At the beginning I've created some query for you (both files attached - just replace addres in Source step).
Before
After
Hi danielbacher ,
Did dufoq3's answer help? If so please help mark it as a solution, this time increase the weight when searching for similar questions, thus helping more people, thanks~
Best Regards,
Gao
Community Support Team