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

Help Robot
,
1

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!

2

@Rohit_Patil1

3

Hi @Rohit_Patil1

Check out the video link

Regards
Gokul

4

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.

5

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

6

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

7

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

8

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

image
image847×276 14.8 KB

1 Like
9

Thanks Gokul. Let me try this one

10

Okay @Rohit_Patil1 Let us know if you face any issue

11

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