Searching column for specified value and then pulling values from other columns in Row

I have a table similar to the above. What I am trying to do is search the table for rows answered yes. Then if yes pull different columns and attach it to a cell ID similar to shown above. The other issue is for each yes we need to increase the cell ID value by 1 as seen below and [3} for a third employee, etc.

Workflow

Datasets

Help

Accepted answers

fmvizcaino

Hi @mabdulh1 ,

Attached is my example.

If this solves your issue please mark the answer as correct, if not let me know!

Hope this helps.

Best,

Fernando Vizcaino

Searching Column.yxmd

fmvizcaino

Hi @mabdulh1 ,

I came with the following solution.

The idea is to use the employee name title as a guide to identify the beginning of the file and then use a filter to remove all header.

Take a look in the example.

Best,

Fernando V.

Dynamic header identifier.yxmd

All comments

fmvizcaino

Hi @mabdulh1 ,

Attached is my example.

If this solves your issue please mark the answer as correct, if not let me know!

Hope this helps.

Best,

Fernando Vizcaino

Searching Column.yxmd

mabdulh1

This is exactly what I mean thanks Fernando. My actual data has 400 names but the table starts about 8 rows down on the excel sheet. The title row is in the excel sheet but I have used the Select tool to rename the column.

Is there a way other than Select Records or Sample tools for me to always search all the employees on the list whether the list has 400 this year and next year it has 500. Or is the select records easier to do and just have to update the records to pull every year.

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703