Transpose operations in Power BI - Cell-by-Cell Formula Trace

Sample Data

Sales data showing products and their sales in Q1 and Q2.

Cell	Value
A1	Product
B1	Q1
C1	Q2
A2	Apples
B2	100
C2	150
A3	Oranges
B3	200
C3	180

Formula Trace

TRANSPOSE({{100,150},{200,180}})

Step 1: {{100,150},{200,180}}

Step 2: TRANSPOSE({{100,150},{200,180}})

Cell Reference Map

    A      B      C
1 Product  Q1     Q2
2 Apples   100    150
3 Oranges  200    180

Formula references cells B2:C3 for sales values.

The formula uses the sales values from cells B2 to C3 to create the matrix that will be transposed.

Result

    A      B      
1  100    200     
2  150    180     

This shows the transposed matrix where original rows became columns.

The result is a matrix where the original sales rows (Apples, Oranges) become columns, and the quarters become rows.

Sheet Trace Quiz - 3 Questions

What does the TRANSPOSE function do to the matrix?

A Adds all values together

B Multiplies each value by 2

C Swaps rows and columns

D Leaves the matrix unchanged

Key Result

TRANSPOSE swaps rows and columns of a matrix or table.