Collection - Transform Rows to Columns

(0) Share

Report

Posted on by Ananda

147

Hello

I'm facing an issue on Collection, Transform Rows to Columns.

My Collection looks like

Title	Quarter	Score
XYZ	Q1	80
XYZ	Q2	60
XYZ	Q4	50
ABC	Q1	90
ABC	Q3	76

I'm looking for

Title	Q1	Q2	Q3	Q4
XYZ	80	60		50
ABC	90		76

How to achieve this ?

Thank you for your support.

ananda

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (1)

JR-BejeweledOne 5,836 Moderator on at

Like (0)

Report
Copy link

Link copied!

Check this out and see if it helps:

https://powerusers.microsoft.com/t5/Building-Power-Apps/Convert-columns-into-rows-in-Power-apps-Data-table/td-p/134705

Was this reply helpful? Yes No
Verified answer

RandyHayes 76,299 Super User 2024 Season 1 on at

Like (2)

Report
Copy link

Link copied!
@ananda

Please consider changing your Formula to the following:

ForAll( GroupBy(yourData, "Title", "_recs" ), {Title: Title, Q1: LookUp(_recs, Quarter="Q1", Score), Q2: LookUp(_recs, Quarter="Q2", Score), Q3: LookUp(_recs, Quarter="Q3", Score), Q4: LookUp(_recs, Quarter="Q4", Score) } )

This will produce the results that you have asked for.

I hope this is helpful for you.

Was this reply helpful? Yes No
Ananda 147 on at

Like (1)

Report
Copy link

Link copied!

WOW, Worked liked charm..
Kudos...

Was this reply helpful? Yes No
lonerwalker 3 on at

Like (0)

Report
Copy link

Link copied!
Hey!

thanks for the advice, but I'm not getting the results in my table , what can I do for this?

ForAll( GroupBy( Forecast; "ItemCode"; "Cliente"; "_recs" //variable auxiliar sacada de una solucion en la comunidad ); { ItemCode: ItemCode; Cliente: Cliente; ENE: LookUp(_recs; Date = "01-01-2023"; Quantity); FEB: LookUp(_recs; Date = "02-01-2023"; Quantity); MAR: LookUp(_recs; Date = "03-01-2023"; Quantity); ABR: LookUp(_recs; Date = "04-01-2023"; Quantity); MAY: LookUp(_recs; Date = "05-01-2023"; Quantity); JUN: LookUp(_recs; Date = "06-01-2023"; Quantity); JUL: LookUp(_recs; Date = "07-01-2023"; Quantity); AGO: LookUp(_recs; Date = "08-01-2023"; Quantity); SEP: LookUp(_recs; Date = "09-01-2023"; Quantity); OCT: LookUp(_recs; Date = "10-01-2023"; Quantity); NOV: LookUp(_recs; Date = "11-01-2023"; Quantity); DIC: LookUp(_recs; Date = "12-01-2023"; Quantity) } )

Was this reply helpful? Yes No