How can I pivot a column and show the dates associated with it?

[Anonymous]

I have some data, shown below, that has repeating values in the Process Step column: Upload, Approve, Forward. I also have a Status Change Date column, the date when the change occurred

My objective is to pivot column E Process Step so that Upload, Approve, Forward are column headers, like shown below:

Do I need to create a new table and do some sort of lookup of these values, or can it be done right in the query as a pivot?

[v-henryk-mstf]

Hi @Anonymous ,

At present, there is no connection between the two screenshot data. Can you provide more test data and information so that I can do further tests.

Looking forward to your reply.

Best Regards,
Henry

[amitchandak]

@Anonymous , refer if this blog can help

https://www.thebiccountant.com/2015/08/12/how-to-pivot-multiple-measurescolumns-in-power-query/

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

[Anonymous]

This unfortunately didn't help much as my specific scenario involves repeating values for the company ID. If I have a primary key that repeats, how can I handle this ?