Forum Discussion

amien's avatar
amien
Icon for Helper V rankHelper V
10 years ago
Solved

split columns in rows instead of columns

how is this possible?    For example:     id, Column 1,A;B;C   should become:     id, Column 1, A 1, B 1, C  
Need Help
Tutorial Requests
  • konstantinos's avatar
    konstantinos
    10 years ago

    Yes with PowerQuery Excel or "Get data" with PowerBI Desktop.

     

    The steps depends on the file/format you import the data but with some test and trial you get there.

     

    Import the data , if is one column then select ( under tab Transform ) Split by "delimeter" and the ","  and you will have 4 columns. Select the ID column and then "Unpivot Other Columns". Then remove the attribute column and you have the format you needed.

     

    6.png

    4.png

     

     

konstantinos's avatar
konstantinos
Icon for Memorable Member rankMemorable Member
10 years ago

Yes with PowerQuery Excel or "Get data" with PowerBI Desktop.

 

The steps depends on the file/format you import the data but with some test and trial you get there.

 

Import the data , if is one column then select ( under tab Transform ) Split by "delimeter" and the ","  and you will have 4 columns. Select the ID column and then "Unpivot Other Columns". Then remove the attribute column and you have the format you needed.

 

6.png

4.png