Forum Discussion

danielbacher's avatar
danielbacher
Frequent Visitor
2 years ago

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" = ...
Need Help
dufoq3's avatar
dufoq3
Community Champion
2 years ago

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

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    1 year ago

    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

  • danielbacher's avatar
    danielbacher
    Frequent Visitor
    1 year ago

    Yes sry for the late respons. Here is an example file from the dataset I'm working on, with expected result.
    https://fld365-my.sharepoint.com/:x:/g/personal/daniel_fld_dk/EYfXvXdoiUFNknz_FRR7OVEB4vC-t0VekYo93sYSHWWpvA?e=Tal5A3 
    The problem I'm having is I have to transpose some of the columns, but not all of them. The columns that should not be transposed doesn't matter if the values in them are duplicated to all rows for each company or they are a single value with the rest of the years blank.
    I only have to transpose the years and all the values after that.