web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps Converting rows to col...

Power Apps

Answered

Converting rows to columns

(0) Share

Report

Report

Posted on by PA-JvdP

43

Hello everyone,

I have a collection which looks as follows:

Name1

Quantity1

Code1

Group1

Supplier1

Date1

Comment1

Name2

Quantity2

Code2

Group2

Supplier2

Date2

Comment2

....

After every 7th row, the pattern repeats and another row should be created in the table I need, as such:

Name	Quantity	Code	Group	Supplier	Date	Comment
Name1	Quantity1	Code1	Group1	Supplier1	Date1	Comment1
Name2	Quantity2	Code2	Group2	Supplier2	Date2	Comment2

Unfortunately, there is no Transpose function available. Can anyone help me achieve this?

Categories:

Building Power Apps

I have the same question (0)

All responses Img

All responses (2)

Answers Img

Answers (1)

Sort by

Verified answer

v-bofeng-msft Microsoft Employee on at

Like (2)

Report
Copy link

Link copied!
Hi @PA-JvdP ,

I assume there is a collection:

ClearCollect(NewCollection,["Name1","Quantity1","Code1","Group1","Supplier1","Date1","Comment1","Name2","Quantity2","Code2","Group2","Supplier2","Date2","Comment2"])

The formula:

ForAll( Sequence(CountRows(NewCollection)/7,0,1), { Name:Index(NewCollection,Value*7+1).Value, Quantity:Index(NewCollection,Value*7+2).Value, Code:Index(NewCollection,Value*7+3).Value, Group:Index(NewCollection,Value*7+4).Value, Supplier:Index(NewCollection,Value*7+5).Value, Date:Index(NewCollection,Value*7+6).Value, Comment:Index(NewCollection,Value*7+7).Value } )

Best Regards,

Bof

Was this reply helpful? Yes No
PA-JvdP 43 on at

Like (0)

Report
Copy link

Link copied!

This worked perfectly, thank you!

Was this reply helpful? Yes No

Join the conversation