How to add new rows

Question

In sheet 1 under Legends column (AO) I want to add more rows with data which are present in sheet 2 without disturbing other columns.

How can it be done?

Legends For community.xlsx

atcodedog05 · Accepted Answer

Hi @sgaryali

You can use union tool with autoconfig by name.

Workflow:

Hope this helps : )