Dynamically serach string and the value in next cell

[hegdepavithra10]

Hi,

I have a excel file as below:

Is there a way to dynamically serach for the string and then the value next to it. For eg: Sum of PL's ,may not occur in the same cell always. How can i dynamically search for that string and the value next to it?

This is my desired output.

So far , i have selecting the columns using select and then using filter tool to segragate it. However my method would be static if the value moved cells.

[atcodedog05]

Hi @hegdepavithra10 

Can you provide the data as a sample file.

[messi007]

@hegdepavithra10,

Please see below:

Hope that helps!

Regards,

[hegdepavithra10]

Hi @atcodedog05 

Here is the sample data. I want to search for the string and the extract the cell next to it. And the output must be in the same format irrespective of where the data may reside. for eg : on the file you will see "Sum PL's" and the data is in A4 and B4, there is a chance that when i use a different file its location may be in E4 and F4. Hence i am looking for how they can be extracted and then placed in the same format mentioned in the out put section:1. Sum of PL's 2.Leaves so on and so forth. There are multiple files with the same data that i have to put under one file.

I hope the requirement is clear.

[atcodedog05]

Hi @hegdepavithra10 

Here is a workflow for the task.

Input:

Output:

Workflow:

Hope this helps 🙂 Feel to ask if you have any questions

If this post helps you please mark it as solution. And give a like if you dont mind 😀👍

[hegdepavithra10]

@atcodedog05 

I am looking for the output to be displayed in the same order as in the screenshot. With the method that you have provided if the position of the values change ,then order will also change. 

[atcodedog05]

Hi @hegdepavithra10 

Here is a workflow for the task.

Workflow:

Hope this helps 🙂 Feel to ask if you have any questions

If this post helps you please mark it as solution. And give a like if you dont mind 😀👍

[hegdepavithra10]

@atcodedog05  I just want to understand for a restricted rows and column from Excel , is there a way to extract searching for a string? For eg : for four rows and ten columns that I select in alteryx for a excel input can I search for "Sum of Pl's" string and the cell next to it ?

[atcodedog05]

@hegdepavithra10 

Sure should be possible

[hegdepavithra10]

@atcodedog05  can the same be implemented for this requirement in that case ?