I have several tables like this:
Table A Table B Col Aa Col Ba Col Ca Col Ab Col Bb Col Cb Col Db 1 Ab1 Ac1 1 Bb1 Bc1 Bd1 2 Ab2 Ac2 3 Bb3 Bc3 Bd3 4 Ab4 Ac4 3 Bb3' Bc3' Bd3'
And I would like to have a resulting table like that
Col X Col Y Col Z 1 Ab1 Ac1 2 Ab2 Ac2 4 Ab4 Ac4 1 Bb1 Bd1 3 Bb3 Bd3' 3 Bb3' Bd3'
It's basically adding all the rows of multiple tables, but manually deciding what columns in each table should be added, and deciding what column from table A goes with what column of table B, and in what column of the final table (and what columns not to add)
I guess I could just do copy paste but I would prefer not to. I could also change the name columns in each table if necessary.
Col Ba = Col Y,
Col Ca = Col Z,
Col Db = Col Zand so on, but again I would prefer not to.
I'm using Excel 2016. Using relationships doesn't work because apparently, data has to be unique in each column (no duplicates)