Create a table with field name and values in rows

[mlim0806]

Hello community, 

I am wanting to create a table for a person profile with field name and values in rows. The issue with the table visual is that the fields run across in columns. In the screenshot below with sample data, the left is how the table is appearing, and the right is how I would like the table to look. Any help is appreciated! thank you!

[Anonymous]

Hi @mlim0806 ,

Can you please share a pbix or some dummy data that keep the raw data structure with expected results? It should help us clarify your scenario and test to coding formula.

How to Get Your Question Answered Quickly  

Regards,

Xiaoxin Sheng

[mlim0806]

It does not look like I have permission to share pbix files. Will this pasted sample data help?

Name	ID	Program	Level	Certification	Current Status	Location	Manager Name	Education	Hobbies
Dean	1	BBC	Manager	Pass	Active	VA	Jason	Bachelors	Golfing
Charles	2	MLL	Vice President	Pass	Active	CA	Lauren	Masters	Swimming
Monica	3	BBC	President	Pass	Active	CO	Tuwana	Masters	Snowboarding
Susie	4	BBC	Manager	Pass	On Leave	MD	Dennis	Bachelors	Fishing
Keilah	5	LLC	Associate	Pass	Active	FL	Won	Bachelors	Fishing

[lbendlin]

What is your preferred sort order?  Have you considered unpivoting the data in Power Query instead?