Showing results for 
Search instead for 
Did you mean: 

Provide a function to transpose/convert rows to columns, or columns to rows

Microsoft Excel provides a function called TRANSPOSE. The documentation for this function is here:




This function enables us to convert rows to columns, or columns to rows. There is often the need to carry out this task in Power Apps, and there is no simple workaround.


Specifically, it's impossible to use data shaping functions to transpose a collection without hard coding the column headings, which makes it extremely difficult to transpose data into an output that contains dynamic column names which correspond to input data values.

Therefore, my suggestion is to provide an implementation of the Excel TRANSPOSE function in Power Apps. The usage of this function would look something like this. Let's take the example of a collection called SalesByRegion.


We would call the Transpose function like so.



The return value from Transpose would be a table that looks like this.




Status: New
Kudo Collector
Kudo Collector

i came here from your blog 🙂


i'm am trying to do the below:

I have 4x screens.

with an Edit form on screen 1 - 3

and then on screen 4 i'm trying to show a summary of the form updates performed on screen 1 - 3.


my idea was to collect the form.updates data from screen 1 - 3, 

then transpose the data and show it in a gallery on screen 4.


unfortunetly a transpose function doesnt exist in Power Apps yet 😞

please add a transpose function 🙂

Regular Visitor

This would be amazing with the Split function. Take a string, split it up into a single column table, then transpose the table so that the former row index becomes the column headers.