Convert data from "Row" to "Excel Column"

Help Studio
, ,
1

Hello Team,

I have a data which i scraped from the webpage and this data showing in one “Row” but i need to convert this as “Column”. See Attached snip for your reference…

Thanks you in advance.

image
image920×852 20.9 KB

image
image1876×142 6.44 KB

Thanks
Rajnish

2

While exracting itself you can extract it as column wise

3

can you give me example plz because after extract i need to update on excel file

4

yeah while extracting use data scraping in data scraping it will apppear as table give the column names and corespondingly the values

share your screenshot while extracting

5

see snip
image
i extracted the data but its showing in row but in excel i need to update in every column

6

Hey

Find Attached File for Your Ref.
Test2.xaml (12.7 KB)
Uploading: Test.xlsx…

Hope it helps.

Regards,
Saloni

7

You can add all values in a list and than use add data row activity to add in a table please check the below workflow for better understanding
Coltorows.xaml (16.4 KB)

8

Hello @Rajnish_Arora

Is it working Fine?