Convert Rows to Column of a Single Record

[hjoshi4u26]

Hello. I am new to PowerBI. I have an excel sheet which has the data in this format.

I need to transform the data into below format.

Can anyone please let me know the steps for this..? It would be of much help.

[hjoshi4u26 · Accepted solution]

Found it.
Here is the video https://www.youtube.com/watch?v=753nK4UBKgo

[Aburar_123]

Hi @hjoshi4u26 ,

You can try like this,

Please Accept this Post as a Solution if it helps. Thanks!

[Padycosmos]

Hope this video helps:

https://drive.google.com/file/d/1na2-YBiK2AGJVbmC85IQiue3E03uVikv/view?usp=sharing

[hjoshi4u26]

Not properly useful.

[andhiii079845]

You are right. I think this is complictated. You have to be sure that you have only 3 or 5 entry per user. And than you have to right code for every column. Why you want this special table? 

[hjoshi4u26]

The table sturcture is fixed. There is only 3 records for each ID and Name, so no problem there. As to why it is required, we have all kinds of managers in this world who have very specific requirements 😄

[andhiii079845]

How you want to sort this Section 1 to 3, per date? 

Section 1 values from the earlist entry?

[hjoshi4u26]

Yes. The dates should be from Left to Right in increasing order.

[andhiii079845]

Do you try the Power Query Editor and the pivot function?
https://support.microsoft.com/en-us/office/pivot-columns-power-query-abc9c8da-3be9-44c4-886e-0be331a...