Need help cleaning nested data

[boylerita]

Hello, need help cleaning data that is nested. The first row is a total row and then the rows beneath it ihave the information broken down. This data continues for 100,000 rows and continually does the same thing with each new industry. Picture attached. Thanks in advance!

[JarekSkudrzyk]

@boylerita hi,

by cleaning data you mean extract the data with information broken down and remove the total rows?
please find example solution

let me know if this answers your question

Btw It is faster to build a solution if you post the data in "copy-easy" format, e.g. text or an alteryx workflow with text input tool:)

[JarekSkudrzyk]

@boylerita 

if you would like to de-pivot the numbers you can use transpose tool: