Export Static Set of Columns plus variable column

Question

Hi -

Been having a tough time googling the right answer on this one... I have a data set that has static information that I want in all of my outputs and then a variable column that is filtered. I think it is best illustrated using a table:

Current Data:

Data1-Data2-Data3-Person1-Person2-Person3
March-Blue-Square-A-Blank-Blank
April-Green-Triangle-S-S-Blank
May-Red-Triangle-Blank-S-A
June-Purple-Pentagon-Blank-Blank-S

Desired Output (as three separate files/tables):

Output 1:

Data1-Data2-Data3-Person1
March-Blue-Square-A
April-Green-Triangle-S

Output 2:

Data1-Data2-Data3-Person2
April-Green-Triangle-S
May-Red-Triangle-S

Output 3:

Data1-Data2-Data3-Person2
May-Red-Triangle-S
June-Purple-Pentagon-S

In other words, I want the Data columns to be in all the output, but I only want one person in each output filtered by if there is a value in the cell (e.g., A/S)

Thank you!

IraWatt · Accepted Answer

Hey @TyGO28,

This setup seems to work:

It Transposes your people onto one row with their details then filters out the blanks. The output tool then outputs changing the file name based on the persons name (not outputting that name in the data).

Any questions make sure to ask :)

HTH,

Ira