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

[mabdulh1]

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.

[fmvizcaino · Accepted solution]

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

[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.

[fmvizcaino]

Can you provide an excel or image to ilustrate the problem? Then I can give you some tip 😃

[mabdulh1]

So here is an example of the excel sheet I have below:

When I input the table below I get this but of course the employee name and indicator 2 would not be null but to get the idea of what im looking at

[fmvizcaino · Accepted solution]

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.

[mabdulh1]

Thanks for your help!!!