I am trying to combine two tables together to return 1 final result set.
My 1st Table labeled as Table A gives a Data Field Layout with its name:
My 2nd Table labeled as Table B gives a full field Layout per unique record:
What I would like to do is to take the Column "REPORTING_DATA_FIELDS" from Table A and only pull the associated Columns in Table B and replace the Column Labels in Table B with the "DATA_FIELD_NAME" from Table A.
The final result set would look like Table C:
Table A contains a different amount of data fields per PROJECT_NAME but the count can be selected to figure out how many columns would be needed.
Any help would be much appreciated!