Forum Discussion
Convert Rows to Column of a Single Record
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.
Found it.
Here is the video https://www.youtube.com/watch?v=753nK4UBKgo
9 Replies
andhiii079845Solution Sage
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-0be331ab387aNot 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?
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 😄
PadycosmosHope this video helps:
https://drive.google.com/file/d/1na2-YBiK2AGJVbmC85IQiue3E03uVikv/view?usp=sharing
- Aburar_123
Solution Supplier
Found it.
Here is the video https://www.youtube.com/watch?v=753nK4UBKgo
