Forum Discussion

dannytan111289's avatar
dannytan111289
Frequent Visitor
5 years ago
Solved

Move every other column into new row

Hi everyone, 

 

i really need your help.  i have set of data with repeated column every 8 columns. I would like to move 21 rows of every 8 column under the row of the first set of data.

 

Any ideas how i can solved this problem?

 

Thanks

 

 

 

Need Help
  • v-kelly-msft's avatar
    v-kelly-msft
    5 years ago

    Hi  dannytan111289 ,

     

    As in power bi ,we cant index columns directly,from my point of view,I would recommend you that first duplicate table then remove columns respectively.

    Take below table for example:

    Split the table into 2 tables as below:

    Then rename the column names in the second table to keep the same with the first one:

    = Table.RenameColumns(Table.RenameColumns(#"Removed Other Columns",{"Phone","CustomerID"}),{"Sex","Name"})

    In the last step,using append to get your expected output:

    For the related .pbix file,pls see attached.

     

    Best Regards,
    Kelly

    Did I answer your question? Mark my reply as a solution!

2 Replies

  • lbendlin's avatar
    lbendlin
    Icon for Super User rankSuper User
    5 years ago

    Please provide sample data in usable format (not as a picture - maybe insert into a table?) .

  • v-kelly-msft's avatar
    v-kelly-msft
    Icon for Community Support rankCommunity Support
    5 years ago

    Hi  dannytan111289 ,

     

    As in power bi ,we cant index columns directly,from my point of view,I would recommend you that first duplicate table then remove columns respectively.

    Take below table for example:

    Split the table into 2 tables as below:

    Then rename the column names in the second table to keep the same with the first one:

    = Table.RenameColumns(Table.RenameColumns(#"Removed Other Columns",{"Phone","CustomerID"}),{"Sex","Name"})

    In the last step,using append to get your expected output:

    For the related .pbix file,pls see attached.

     

    Best Regards,
    Kelly

    Did I answer your question? Mark my reply as a solution!