Data cleansing - Headers in dataset, replace data etc

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!

Sample data - Alteryx.xlsx

Help

Accepted answers

@evnlxy
find the workflow attached

Mark done if solved.

All comments

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!

@evnlxy
find the workflow attached

Mark done if solved.

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

Quick Links

Tags

This months top contributors

Hollingsworth 335