Unanswered

Transpose a Recorded List into multiple Excel Columns

(0) Share

Report

Posted on by hello11

Hi Community,

I have tried several options, but I am not solving it.
I have a 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 - this output is only 1 column.
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:

itemA1
itemA2
itemB1
itemB2

itemC3

itemC4

Now the issue is writing the transposed values as columns in Excel.

The desired output would be like:

Col1,Col2
itemA1,itemA2

itemB1,itemB2

itemC3, itemC4

My issue is looping each time x items for different rows. For example, from row 1-5 (Extract Data) write in the first row (Excel File), from row 6-10 (Extract Data) write in 2nd row (Excel File) and so on. It repeats each time.

Can you help me?

Thanks in advance.

Categories:

Power Automate Desktop

All responses (4)

Answers (0)

Sort by

CU16071609-1 6,255 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

@hello11

The above-mentioned row numbers are static, or it will change on each iteration.

If possible please share some screenshot of your webpage extracted variable.

Thanks,
Deenuji Loganathan 👩‍💻
Automation Evangelist 🤖
Follow me on LinkedIn 👥

-------------------------------------------------------------------------------------------------------------
If I've helped solve your query, kindly mark my response as the solution ✔ and give it a thumbs up!👍 Your feedback supports future seekers 🚀
hello11 44 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Deenuji,
Iteraction is static - repeats each 15 times (in my case).
The example that I have written before is a dummie that suits my case.
Thank you in advance!
hello11 44 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Deenuji
Please see attached a sample of WebPageData.
Thanks.

sample.xlsx
hello11 44 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Deenuji
Please see attached a sample of WebPageData.
Thanks.

sample.xlsx