Output Sheets by country + Master sheet

Dear Community,

After searching hours, I gonna need your support here...

I have below data set:

#	Country
1	Argentina
2	Brazil
3	Bolivia

I need to output within the same workbook below structure:

1- Sheet that contains the above table "as is".

2- One sheet per country.

I know that If I set up the output this way (Change file/table name using the column [Country]) I will get one sheet by country....but I loss the single sheet that contains the table above...

Is there any way I can obtain both results same output file?

Any training material available I couldn`t find?

Thank you!

Henry

Interface Tools

Accepted answers

RolandSchubert

Hi @Henrytabares ,

there is no additional option in terms of "output original sheet in addition", but you could create a duplicate of the original sheet.

I create a copy of the original sheet and an additional column with the sheet name for the "master table". In addition, I create this column for the "detail sheet" (i.e. the original data set), union original and copy and use output tool, change table name by the new column and do not include it in output.