Concatenate data from several tabs into one. If concatenated tabs have different columns, missing columns will be added to the tab being merged into.    

  1. Select the tabs containing the data you want to concatenate. In each selected tab, the merged data is the output of the last step. 
  2. Select the option Show source column in order to display a column of tags to track the provenance of each row 

Example

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.   

Did this answer your question?