cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous
Not applicable

The question of data transpose

hi all

 

I have a problem with data editing, as shown in the first picture below, which is my basic data

old.png

 

I want to convert it to this picture

In the second image I turned the location column into a row and filled in the values for the next three fields

new.png

 

Can this be solved by M function? If so, thank you very much

 

Best Regards

alan-li

 

1 ACCEPTED SOLUTION
mussaenda
Super User
Super User

Hi @Anonymous ,

 

Based on your basic data, we can achieve your desired output using Matrix Table

2019_09_03_11_12_39_Settings.png

 

If I am not mistaken, M Query cannot have sub column like you wanted on the second column.

View solution in original post

8 REPLIES 8
mussaenda
Super User
Super User

Hi @Anonymous ,

 

Based on your basic data, we can achieve your desired output using Matrix Table

2019_09_03_11_12_39_Settings.png

 

If I am not mistaken, M Query cannot have sub column like you wanted on the second column.

Anonymous
Not applicable

hi @mussaenda 

 

Excuse me I solved the problem.

 

Best Regards

alan-li

Good to know you have solved the problem

Anonymous
Not applicable

hi @mussaenda 

 

I would like to know if I can export the data according to the template of my table

I haven't found the relevant information, please let me know if you know thinks

 

Best Regards

alan-li

Hi @Anonymous ,

 

You cannot.

There is a workaround but it needs time and effort.

If you really wanted to export the matrix style, save first the page in pdf then convert pdf to excel.

 

Anonymous
Not applicable

hi @mussaenda 

 

ok, thinks a lot

 

Best Regards

alan-li

Anonymous
Not applicable

hi @mussaenda 

 

Why is mine displayed like this

Is there something else I need to set up, I just found the drill data

aa.png

 

Best Regards

alan-li

Anonymous
Not applicable

hi @mussaenda 

 

That will do. Thank you very much

 

Best Regards

alan-li

Helpful resources

Announcements
PBI Sept Update Carousel

Power BI September 2023 Update

Take a look at the September 2023 Power BI update to learn more.

Learn Live

Learn Live: Event Series

Join Microsoft Reactor and learn from developers.

Dashboard in a day with date

Exclusive opportunity for Women!

Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!

Top Solution Authors