Forum Discussion
Solved
Append only shows first selected table data properly
Hi All I am in power query section of the excel and i have created two subset tables from one very large data set. Imperial_Table (blue color table) and _Metric_Table (orange color table). I am b...
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.
Hi. Thank you so much. It worked like a charm. Thanks for being awesome !