Forum Discussion
Rylane Goncalez
Mar 05, 2018Copper Contributor
I need help with a formula
Hi, I need help with a formula please! I have an excel sheet with multiple tabs. So on sheet 1 I have all master data and on sheet 2, I break out a section of the data. In the example below, we a...
SergeiBaklan
Mar 05, 2018Diamond Contributor
Hy Rylane,
Perhaps the easiest way is to use Power Query (aka Get&Transform) - query your master table, unpivot columns with codes, filter on Yes, make bit more cosmetic and load the result into another sheet.
Deleted
Mar 05, 2018I am trying to achieve the same in Powerapps. Would anyone know how I could do this in powerapps?