Create a table with field name and values in rows

Question

Hello community,&nbsp;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!&nbsp;&nbsp;

lbendlin · Answer

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

anonymous · Answer

Hi mlim0806&nbsp;,
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&nbsp;&nbsp;
Regards,
Xiaoxin Sheng

mlim0806 · Answer

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

Forum Discussion

Create a table with field name and values in rows

3 Replies

Related content

Create new table

Lakehouse Table Generate Create Table

Create rows from 2 tables

Create Table with Escalating Values

Creating Date Tables