please help with this table transpose, please see details

[ryanzhang487]

Hi community, I have a table shown as "now", I would like to transpose it to "expected", please see screenshots

how can I do that please?

The excel is attached,

Thank you very much

now:

expected: 

  

[Yoshiro_Fujimori · Accepted solution]

Hi @ryanzhang487 ,

Hiere is one way of doing this.

I assume you want to summarize the number, and to show the number in "$" format.

Otherwise, the Multi-Field Formula and Select Tool could be omitted.

Good luck.

[binuacs]

@ryanzhang487 Another method