How to get the cell value of their respective column in excel

Hi, I want to read the cell values which is below their columns.
image

Here I want to read the values row wise according to their column name
Expected output look like below
image

Thanks in Advance!

@Rohit_Patil1

Hi @Rohit_Patil1

Check out the video link

Regards
Gokul

Thanks for the response Sangeetha. I want to search the column in data table and pick the value below that column. Transpose excel will not useful here.

Hi Gokul, I want to find the columns in data table and pick the value of respective column.
Thanks

Hi @Rohit_Patil1

In what bases you are going to search can you tell us more detail with the sample input and expected output as well.

Regards
Gokul

Sure! So I have multiple columns in excel and their values are below of that column as attached in screenshot. So I have to find the column name and according to the column I have to get the value of that column as attached in screenshot

Hi @Rohit_Patil1

To find some value in excel use Look up Range activity

And get the Range of the value and pass it after the check out the video link for transpose data

1 Like

Thanks Gokul. Let me try this one

Okay @Rohit_Patil1 Let us know if you face any issue

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.