Forum Discussion

Aurora-BI's avatar
Aurora-BI
Helper I
2 years ago
Solved

How to Transpose / transform multiple rows into a few columns

Hi Everyone,    I need a little help figuring out how to transpose or transform some data in my Power BI report. Every 19 rows, the data "repeats" so I am thinking I will need a table with 1...
Need Help
  • Aurora-BI's avatar
    Aurora-BI
    2 years ago

    I figured this out, with help from slorin 

     

    The formula I needed was: 

    = Table.FromRows(
         List.Split(Your_Source[Column2],18),
         List.FirstN(Your_Source[Column1],18)
    )

     

slorin's avatar
slorin
Super User
2 years ago

Hi

 

= Table.FromRows(
     List.Split(Your_Source[Column2],19),
     List.FirstN(Your_Source[Column1],19)
)

 Stéphane