Forum Discussion

Rohit_23's avatar
Rohit_23
Regular Visitor
3 years ago
Solved

Copying/Transfrom multiple columns under each other.

Hi, I want to transform my data such that every time i update my excel sheet, bi should transform the data such that all the specified columns are below each other. Raw Data: Country Region P...
  • DOLEARY85's avatar
    3 years ago

    HI,

     

    you could unpivot the columns in power query. If you are likely to have more quarters than just the 3 listed there - select all the columns except the quarters, right click and select unpivot other columns.

     

    If I answered your question, please mark my post as solution, Appreciate your Kudos 👍

  • DOLEARY85's avatar
    DOLEARY85
    3 years ago

    Okay, so all you have to do is go into power query select the ones you don't want in one column, right click the selection and select unpivot other columns

     

    If I answered your question, please mark my post as solution, Appreciate your Kudos 👍