I ended up editing the values in table1 column "column", so instead of just having the numbers now we habe the complete column number name like column1 instead of 1, and so on... then used a unpivot command and then an inner join...