Convert records into rows and columns

[pal95]

Hi, I have the following query:

There are about 370 records, and each contains the same 3 columns:

I would like to unzip it into 370 rows and 3 columns, so my columns are: OEE, Shift, Timestamp, and my rows are just the values for each record. Is that possible somehow? Thank you

[slorin]

Hi, @pal95 

= Table.FromRecords(Source[rows])

Stéphane 

[pal95]

Sorry, but it doesn't work.

What is the source and what should stand for rows?

[pal95 · Accepted solution]

This was bad advice, I used a custom column to create 3 columns from records like Record.Field([Column1], "Shift")

[slorin]

Hi,

https://learn.microsoft.com/en-US/powerquery-m/table-fromrecords

Stéphane 

[pal95]

Hi, how to scale that into 370 records? Could you please provide a pattern so I can follow that? thank you