How to extract data from a list of records

[uj_Gladiator]

Each record has these 5 elements, I want to convert this into a single table with column headers: visitorid, accountid, poll response, time and qual poll response. The data from each record should be a row in the table. 

Any idea on how to go about this? I have zero experience with M code, I was just trying to automate the ETL process for a dashboard and got stuck on this stage. Would be greatful to anyone who can help me out.

Thanks,
UJ

[uj_Gladiator]

It worked! thanks a ton

[AlienSx · Accepted solution]

Hi, @uj_Gladiator 

    Table.FromRecords(
        List.Transform(
            Source[results], 
            each Record.RenameFields(
                _, 
                {
                    {"visitorId", "visitorid"}, 
                    {"accountId", "accountid"}, 
                    {"pollNumResponse", "poll response"}, 
                    {"pollQualResponse", "qual poll response"}
                }
            )
        )
    )

or just Table.FromRecords and rename table columns afterwards.