I have two tables, each in it’s own sheet in the same file:
Name Age Alice 18 Bob 19 Carol 20 Dave 19 Name Gender Bob Male Dave Male Eve Female
I want to automatically create a third table (sheet) that contains the joined data on the column name:
Name Age Gender Bob 19 Male Dave 19 Male
edit for readability by @karolus
Is this operation supported in LibreOffice Calc?