Forum Discussion

Misq's avatar
Misq
Icon for Helper I rankHelper I
4 years ago
Solved

Transforming Columns with comas to separate rows

Hi all, Is it possible to transform data from green table (image below) so they will be looking as data in the blue one? I've tried to unpivot them, but fo course it dosent work. I dont beliv...
Need Help
Tips and Tricks
Dhacd's avatar
Dhacd
Icon for Resolver III rankResolver III
4 years ago

Yes, this can be achieved using power query,

Can you copy and paste the green data set in your picture as a reply? 
I will share the steps as screenshots.

Thanks and regards.

Misq's avatar
Misq
Icon for Helper I rankHelper I
4 years ago

Hi Shaved,

Can it be a simple excel file or pbix? I will definitely post it 😉

  • Dhacd's avatar
    Dhacd
    Icon for Resolver III rankResolver III
    4 years ago

    Just copy the cells from A1 to C3 from the excel to the reply box and I will take it from there 😄

    • Misq's avatar
      Misq
      Icon for Helper I rankHelper I
      4 years ago

      So, here it is:

      IDOrderdItemOrderDates
      11,2,22020-01-01, 2020-02-01, 2020-03-01
      21,1,3,32020-01-01, 2020-02-01, 2020-03-01, 2020-04-01
      • Dhacd's avatar
        Dhacd
        Icon for Resolver III rankResolver III
        4 years ago

        First, select the column and click on the split column button in the Home ribbon, Then select by the delimiter

        In the popping, window Select the delimiter as a comma and click on advance and under split into choose row radio button. Then click on Okay.

        Do the same for the other column and you are done.
        Mark as solutions so others can find this easily. 😄

        Thanks and regards.