web

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

News and Announcements icon

Power Platform CommunityForums Power Apps Transpose rows to columns

Power Apps

Answered

Transpose rows to columns

(0) Share

Report

Report

Posted on by Sam70

285

Hello,

Below is a sample data where rating has been provided by Auditor against an Account.

I need the same data inside a gallery but in a different format.

Rating1 to Rating4 (4 columns are fixed). Need formula to generate the above.

Regards

Categories:

Building Power Apps

I have the same question (0)

All responses Img

All responses (1)

Answers Img

Answers (1)

Verified answer

BCBuizer 22,854 Super User 2026 Season 2 on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Sam70 ,

This can be done using a vertical gallery and a nested horizontal gallery:

First insert a blank vertical gallery and set the Items property to:

GroupBy( 'List A', "Account, "Auditor","Audit_x0020_Month", "GroupedItems" )

Then insert three labels inside the gallery with their respective Text properties set to

ThisItem.Auditor
ThisItem.Account
ThisItem.'Audit Month'

Then add a blank horizontal gallery inside the vertical gallery and set its' Items property to:

ThisItem.GroupedItems

Finally insert a label inside the horizontal gallery and set its' Text property to:

ThisItem.Rating

Was this reply helpful? Yes No

Join the conversation