Fix spreadsheet structure (title, headers, items, blank - repeat)

[Anonymous]

Hello to everyone,

I'm trying to work with an exported excel spreadsheet which has the following (bad) structure. Unfortunately is system export, so I can't change it automatically. Manual fix would be too much.

Part Number1 (10 digits: 9 numbers, 1 text, e.g. 123456789A)	null	null	null	null
Pos.	title	quantity	...	...
1
2
..
N (variable!)
null	null	null	null	null
Part Number2
Pos.	title	quantity	...	...
1
2
..
N (different from the table before)
null	null	null	null	null
Part Number3
....

What I tried so far:

I can't split by fixed number of rows, as it isn't fixed.

By importing with suggested tables I can split properly, but can't get the Part Number out of it and this is a problem as I lose the most important info.

A perfect solution would be to recreate the pivot, with part number as 1st column. I tried adding new column from example, but it doesn't find correlations as I expect and I'm stuck.

Thanks in advance for support!

[lbendlin]

Please provide sanitized sample data that fully covers your issue.

Please show the expected outcome based on the sample data you provided.