web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Transposing a Recorded...
Power Automate
Answered

Transposing a Recorded List to Excel Columns

(1) ShareShare
ReportReport
Posted on by 25

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?

I have the same question (0)
  • Verified answer
    glennh Profile Picture
    Microsoft Employee on at

    Hi 

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

     

    glennh_0-1620555080479.png

     

  • nicoper Profile Picture
    25 on at

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

  • glennh Profile Picture
    Microsoft Employee on at

    Glad I could help you, good luck!

  • ryule Profile Picture
    929 Super User 2024 Season 1 on at

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

  • asakki13 Profile Picture
    9 on at

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

     

    asakki13_0-1708336119527.png

    output will be as in excel 

    306.00  586.00

     

  • asakki13 Profile Picture
    9 on at

    Hi,

     

    Output appears in excel as below:

     

    TelephoneItem 1Item 2Item 3Item 4    
    208530269171834917917    
    20853028    306586  
    20853031      2360 
    20853035       1429
             

     

    Please help.

     

    Regards

  • asakki13 Profile Picture
    9 on at

    Hi,

    Output appears as below in excel:

    TelephoneItem 1Item 2Item 3Item 4    
    208530269171834917917    
    20853028    306586  
    20853031      2360 
    20853035       1429
             

     

    Please help

     

  • FlashDota Profile Picture
    20 on at

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

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 503 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 321 Moderator

#3
abm abm Profile Picture

abm abm 237 Most Valuable Professional

Last 30 days Overall leaderboard