Table Visualization - from columns to rows

[chyang0107]

Hey everyone,

I would need your help on how to transpose the data from columns to rows by using Table visualization. Could I know if you could provide your insights on this task

Current table visul

ID	Grant Manager	Grant_Start	Grant_End
20001	Mary	04/01/2022	03/31/2026

Expected table visul

ID	20001
Grant Manager	Mary
Grant_Start	04/01/2022
Grant_End	03/31/2026

Thanks,

Hank

[chyang0107]

Hey Fahad,

I appreciate your reply and insights. I am sorry to mislead you in my original post. My workflow (listed below) allowed the user to select a project by dropdown list, and then the final table visualization would demonstate the information associated from a wide and long table by the matching the id. It means the example in the first post was not the original table but the resulting table visualization.   

Your insights on how to transpose the columns to rows based on my configuration would be appreciated. 

[fahadqadir3 · Accepted solution]

Result

@chyang0107 I duplicated the table just for this example, you don't need to duplicate it. You first need to select all column and unpivot. For filter the table by ID i create a new column in PQ and use fill down. Power BI file attached.

Power Query Transformation

Unpivot Columns pbix.pbix

Regards,

Fahad Qadir

Did I answer your question? Mark my post as a solution! Appreciate your Kudos !!