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
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Welcome Super Users.jpg

Super User Season 2

Congratulations, the new Super User Season 2 for 2021 has started!

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.

Microsoft Ignite 768x460.png

Find your focus

Explore the latest tools,training sessions,technical expertise, networking and more.

Top Solution Authors
Top Kudoed Authors
Users online (2,458)