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 19 coulmns. "Date" , "Builder ID", "Part Number", etc. 

 

But when I try to use transpose, I go to having 2 rows with 1000's of columns. Is there a step I am missing in formatting this data? Any assistance would be greatly appreciated. 

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)
    )

     

4 Replies

  • 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

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

      slorin 

       

      Thank you for the feedback. When I try to implement this solution, I get this error: 

      Is there perhaps something I have missed? 

  • Aurora-BI's avatar
    Aurora-BI
    Helper I
    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)
    )