SQL querie : Creating a table based on common fields

[Marie-JoëlleDesgagné]

Hello everyone !

I don't really know how to explain what I want to do so here is a example of it:

MarieJolleDesgagn_0-1628868973198.png

Anyone knows how to do that ? Thanks a lot !!

[DavidPike]

https://pro.arcgis.com/en/pro-app/latest/tool-reference/data-management/pivot-table.htm

[Marie-JoëlleDesgagné]

Ok thank you. And what if I have more than one value field ?

[DavidPike]

can you give an example?