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!

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]

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

Help Robot

sangeethaneelavannan1 (Sangeetha Neelavannan) December 5, 2022, 10:32am 2

@Rohit_Patil1

Topic		Replies	Views
Datatable string Help	2	1695	November 29, 2018
Get value from excel Help	4	843	October 30, 2019
To read the row from one excel and save it as columns in another excel Studio datatable , excel , activities , question , data_manipulation	6	897	September 23, 2020
Get value of selected excel cell Help excel	8	6197	July 29, 2019
Can we read all the data of a Data Column if the column variable is given? Activities datatable , excel , activities , question	4	612	May 10, 2021

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

Related topics