Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

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
Community Champion
Community Champion

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
Community Champion
Community Champion

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
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

February 2024 Update Carousel

Power BI Monthly Update - February 2024

Check out the February 2024 Power BI update to learn about new features.

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.