Forum Discussion
Fix spreadsheet structure (title, headers, items, blank - repeat)
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!
1 Reply
Please provide sanitized sample data that fully covers your issue.
Please show the expected outcome based on the sample data you provided.
