I would like to do the opposite of the CROSS TABLE function
I have a first table called CONTRIB_TABLE which has only one column named "Contributor":
I have a second table named SP_TABLE which has 4 columns:
Project ID | Project Name | Project Status | SP
For each contributor in the CONTRIB_TABLE I would like to add a new column in the SP_TABLE in order to obtain
Project ID | Project Name | Project Status | SP | A | B | C | D | ...
Would you have a solution ?
Thank you !