How to Transpose / transform multiple rows into a few columns

[Aurora-BI]

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. 

[Aurora-BI · Accepted solution]

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

[Aurora-BI]

I get this error when using my original data source: 

[slorin]

Hi

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

 Stéphane

[Aurora-BI]

@slorin 

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

Is there perhaps something I have missed?