Opposite of a cross table

[stephane_veriss]

Hello everybody,

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":

Contributor

A

B

C

D

...

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 !

[sunny_talwar · Accepted solution]

Opposite of CrossTable would be The Generic Load