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:

Shivakks's avatar
Shivakks
New Member
4 years ago

HI kiranbchitari ,

 

Please update the solution to this problem as i am looking for the same answer similar to yours.

 

Regards,

Shiva