Forum Discussion
Append only shows first selected table data properly
You could use Table.FromColumns instead of appending:
Table.FromColumns( Table.ToColumns(Table_Imperial) & Table.ToColumns(Table_Metric), Table.ColumnNames(Table_Imperial) & Table.ColumnNames(Table_Metric) )This splits both tables into a list of columns, joins the resulting lists, and then reassembles them into a single table using the column names from each table.
For a simpler example, suppose we have two tables Imperial_Table and Metric_Table as follows:
Appending them together gives the following result:
This is probably not what we actually want, but since there are no matching column names, Power Query doesn't know which columns should stack on which other ones.
One way to fix this would be to standardize the column names on the tables before appending. For example, these tables should append as expected:
Thank you so much taking the time to respond. I guess then my question was wrong. I apologize for that. All I want in my final table to is to bring selected tables side by side to make a "joined" table by rearranging the columns in that final table as shown in the screenshots. I want to go from 1st picutre to 2nd picture. I dont want to disturb the column arrangement of Master file (first picture) as its a downloaded copy from the internet .