Concatenate data from several tabs into one. If concatenated tabs have different columns, missing columns will be added to the tab being merged into.
Select the tabs containing the data you want to concatenate. In each selected tab, the merged data is the output of the last step.
Select the option
Show source columnin order to display a column of tags to track the provenance of each row
Tab 1 has 3 columns
Tab 2 only has 2 columns
When merging Tab 1 into Tab 2, the missing column (Age) is added. Rows from Tab 1 have null values in Age, since the data is missing in the tab of origin.