cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
nicoper
Frequent Visitor

Transposing a Recorded List to Excel Columns

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?

1 ACCEPTED SOLUTION

Accepted Solutions
glennh
Microsoft
Microsoft

Hi 

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

 

glennh_0-1620555080479.png

 

View solution in original post

3 REPLIES 3
glennh
Microsoft
Microsoft

Hi 

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

 

glennh_0-1620555080479.png

 

View solution in original post

nicoper
Frequent Visitor

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

Glad I could help you, good luck!

Helpful resources

Announcements
Process Advisor

Introducing Process Advisor

Check out the new Process Advisor community forum board!

MPA User Group

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

V3_PVA CAmpaign Carousel.png

Community Challenge - Giveaways!

Participate in the Power Virtual Agents Community Challenge

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

Users online (3,430)