I think you need to make 'Meeting' a column, rather than a set of columns, so recut your data by loading as follows
'X' AS Meeting,
Meeting_x AS Meeting_Identifier
'Y' AS Meeting,
Meeting_y AS Meeting_Identifier
Then drop your original table1.
A neat way of achieving this is via a mapping load and then a cross table.
Refer to attachment and see if it achieves what you are after.
I have tried to comment the code to tell you my thought process.
Hope that helps!