Data cleansing - Headers in dataset, replace data etc

[evnlxy]

Hello,

I have a dataset which I am trying to clean up to create a PivotTable. However, there are header rows included in the dataset and information applicable to rows following certain data - I have attached the input data as well as desired output and would appreciate any help in coming up with a workflow.

Thank you!

[alexnajm]

I would look at using a Multi Row Formula to cascade the first column down so you have the 1, 2, etc. repeat for every row. Then you would use likely a RegEx Match filter to make sure you only keep records where that column is numeric!

[Raj · Accepted solution]

@evnlxy 
find the workflow attached

Mark done if solved.

[evnlxy]

Thank you so much this is exactly what I was looking for, much appreciated!