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

[kiranbchitari]

Fig 1

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.  

[v-danhe-msft · Accepted solution]

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

[Shivakks]

HI @kiranbchitari ,

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

Regards,

Shiva

[v-danhe-msft · Accepted solution]

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 · Accepted solution]

Thanks for your interest. I resolved the problem.

[v-danhe-msft]

Hi @kiranbchitari,

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

Regards,

Daniel He