Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

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   I want to convert it to this picture In the second image I turned the location co...
Need Help
  • mussaenda's avatar
    mussaenda
    7 years ago

    Hi Anonymous ,

     

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

     

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

mussaenda's avatar
mussaenda
Icon for Community Champion rankCommunity Champion
7 years ago

Good to know you have solved the problem

Anonymous's avatar
Anonymous
Not applicable
7 years ago

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

  • mussaenda's avatar
    mussaenda
    Icon for Community Champion rankCommunity Champion
    7 years ago

    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's avatar
      Anonymous
      Not applicable
      7 years ago

      hi mussaenda 

       

      ok, thinks a lot

       

      Best Regards

      alan-li