Transposing a Recorded List to Excel Columns

[nicoper]

Hello All

Hopefully you could help with this problem we're having:
We want to record a few table elements from a web page and store them as columns in Excel.

We go to "Extract Data from Web Page" and record the items we want.
By selecting the first two, the recorder selects them all and stores them in a List.
A display popup is clearly showing that it is correctly picking the data we want, like this:

item1
item2
item3
item4

Now the problem is writing the transposed values as columns in Excel.
(By default its writes them in consecutive rows)

The desired output would be like:

Col1,Col2,Col3,Col4
item1,item2,item3,item4

How can we do that?

[glennh · Accepted solution]

Hi 

You can use For each together with a column counter variable.

[nicoper]

Beautiful.. You solved it elegantly.
Thanks a million.

[glennh]

Glad I could help you, good luck!

[ryule]

Just wanted to post and say thank you as well; appreciate it @glennh !

[asakki13]

How to transpose extracted data from web page (Column) to write to excel in row.

output will be as in excel 

306.00  586.00

[asakki13]

Hi,

Output appears in excel as below:

Telephone	Item 1	Item 2	Item 3	Item 4
20853026	917	1834	917	917
20853028					306	586
20853031							2360
20853035								1429

Please help.

Regards

[asakki13]

Hi,

Output appears as below in excel:

Telephone	Item 1	Item 2	Item 3	Item 4
20853026	917	1834	917	917
20853028					306	586
20853031							2360
20853035								1429

Please help

[FlashDota]

After the for-each transposed data loop set the coldindex to 0, so then the next loop it starts from 1 again