Forum Discussion

JoshHall's avatar
JoshHall
New Member
5 years ago
Solved

Appending columns

I have a set of data that looks like this example (although th real one has >600 "log work" columns, each of which has a name, date and time which I intend to extract after I figure this part out) ...
Need Help
  • v-robertq-msft's avatar
    v-robertq-msft
    5 years ago

    Hi, JoshHall 

    According to your description, I think you can get the expected data through the Power Query editor, you can follow my steps:

    1. Go to the Power query editor, select the column [Assignee], click Unpiovit-> Unpiovit other columns:

     

    1. Remove the second column:

     

    And you can get what you want, like this:

    You can download my test pbix file here

     

    Best Regards,

    Community Support Team _Robert Qin

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

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

Hi, JoshHall 

According to your description, I think you can get the expected data through the Power Query editor, you can follow my steps:

  1. Go to the Power query editor, select the column [Assignee], click Unpiovit-> Unpiovit other columns:

 

  1. Remove the second column:

 

And you can get what you want, like this:

You can download my test pbix file here

 

Best Regards,

Community Support Team _Robert Qin

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.