NEED URGENT HELP MAKING THIS INTO A TABLE where data in its separte rows

[Sivory18]

Need help forming the table. As you can see there a few column where the headings are, just want 1 line of heading at the start and split the data, as the data in 1 row, instead of columns

[OTrieger]

@Sivory18 

Import the data into Alteryx and then add RecordID tool. Add Summarise Tool and then Group data based on first column and Mix RecordID. Now you will have the first RecordID for the headers, filter out all the RecordIDs that are smaller and now You Dynamic Renaming tool and make the first row into Headers. All what you are left now is to filter out all the rows that does not containing the data. Obviously this is a high description on what to do. There will be additional steps that requires however you should be able to figure out how to do it.