i have a data set where in i take value from one table which itself is a column in another table. it would look something like this.
TABLE1
ID CATEGORY ACTIVITY
551 ML ART
552 PTL SWEEPS
553 RDC PIPO
554 ML PIPO
TABLE2
ACTIVITY ML PTL RDC
ART 10 15 15
PIPO 15 15 11
SWEEPS 12 10...