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.