Read a data table and extract values from rows

[chauhan.rachita30 (Rachita30)]

I am extracting a data table from a Chrome browser:
This is the Table format I get:

here the Column headers are listed in the first column. (instead of header row).
I need to extract Operating status and Legal Name.
Kindly help.
Thanks
Rachita

[Edwin_Barahona]

Hi @chauhan.rachita30 ,

I understad you’re looking to transpose your items. To make your life easier I found this resolved in the following topic.

How to move row items to column(Transpose) in excel using UiPath

Hi, I came across a scenario where I needed to move row values to column /, in other words, transpose. In another similar thread, I found a package that does the work, but I want to learn to make it happen without the use of packages and do it a hard way, can anyone help me with this? Thank you.

[kumar.varun2 (Varun Kumar)]

Hi @chauhan.rachita30

You can try this approach

Xaml for reference

ExtractValueFromRows.xaml (7.6 KB)