Multiple lines into columns

[Anonymous]

Dears,

I have a table with multiple status lines and timestamps, what I'm trying to do is to move the timestamps into columns as in the following example:

How can I replicate this result in PowerBI?

Thank you for your support!!

T

[AlB · Accepted solution]

Hi @Anonymous 

You can use the pivot/unpivot feature in the query editor. Check this out:

http://radacad.com/pivot-and-unpivot-with-power-bi

https://support.office.com/en-us/article/unpivot-columns-power-query-0f7bad4b-9ea1-49c1-9d95-f588221c7098

[Nolock · Accepted solution]

Hi @Anonymous ,

you can do that with Pivot Column in the Power Query Editor.

You select the column Status and click on Pivot Column and than you chose the column Date as you can see on the screenshot below. The screenshot shows the result.

[AlB · Accepted solution]

Hi @Anonymous 

You can use the pivot/unpivot feature in the query editor. Check this out:

http://radacad.com/pivot-and-unpivot-with-power-bi

https://support.office.com/en-us/article/unpivot-columns-power-query-0f7bad4b-9ea1-49c1-9d95-f588221c7098