I have an excel sheet that I want to export to sql database. However, the excel file and the row items are not haveing a consisten schema, meaning there is a need to create a separate sheet that reads through the sheet and creates a schema out of the data.
It will be done updates to the original spreadsheet by adding, modifying and deleting product items so this needs to be reflected in the new spreadsheet and the schema created there.
the attached file shows the list of products which are just dumped into rows. However, the only predictable columns are Column D where the category names are registered. Column F,G,H are also predictable as they provide the size, year of production, price.
All the other items in the Column A need to be structured under level 1 through level 4 headings as they are actually hierarchicaly related.
an example row as expected row within the sql database is also provided.
the sample row is created from the main file from row 107-114.
I want an excel sheet that enables users to continue update the product list as is, but have another sheet within the same file to do its magic on the changes within the original sheet and create a structured schema that can be used for export to the database.