Operation-Fill,Stack and Remove Duplicates

Fill, Stack and Remove Duplicates

Goal: Setup a workbook formula that adds anonther column in the two given tables, stacks them vertically and removes any duplicate data if present.

Input: Download sample file from here.

Hint:

  1. In Sheet 1, add another column Year, extract year from the Date column (Use =Year() function) for the first data row only.

  2. Click on Fill in Sheetkraft Operations tab and it will get the data using above formula for the given rows.

  3. Repeat above two steps for data in Sheet2.

  4. Now, use Stack Rows opeartions to combine the two tables.

  5. For the generated combined table apply the Remove Duplicates operation to remove any duplicate data.