Forum Discussion

kiranbchitari's avatar
kiranbchitari
Frequent Visitor
8 years ago
Solved

How we can display row data into column and below that column values of some other column?

Figure 1 is an original table how I can convert this into Fig 2. the values below beauty, brain, and shape are the corresponding benchmark performance.      
Show and Tell
Tutorial Requests
  • v-danhe-msft's avatar
    v-danhe-msft
    8 years ago

    Hi kiranbchitari,

    Based on my test, I could use the group by function to group your data by [Year] column, but I couuld not figure out your logic in your desired picture, also due to both your [Benchmark1] and [Benchmark2] has multiple data, could you please tell me which column your desired result is based on?

     

    Regards,

    Daniel He

  • kiranbchitari's avatar
    kiranbchitari
    8 years ago

    Thanks for your interest. I resolved the problem.:smileyhappy:

v-danhe-msft's avatar
v-danhe-msft
Icon for Microsoft Employee rankMicrosoft Employee
8 years ago

Hi kiranbchitari,

Based on my test, I could use the group by function to group your data by [Year] column, but I couuld not figure out your logic in your desired picture, also due to both your [Benchmark1] and [Benchmark2] has multiple data, could you please tell me which column your desired result is based on?

 

Regards,

Daniel He

  • kiranbchitari's avatar
    kiranbchitari
    Frequent Visitor
    8 years ago

    Thanks for your interest. I resolved the problem.:smileyhappy:

    • v-danhe-msft's avatar
      v-danhe-msft
      Icon for Microsoft Employee rankMicrosoft Employee
      8 years ago

      Hi kiranbchitari,

      It's pleasant that your problem has been solved, could you please mark a reply as Answered?

       

      Regards,

      Daniel He