Uniclass Sorting

[AB1-Airtable]

Hello!

Newish to Airtable, sorry.

I am trying to sort a table that consists of all of the ISO 19650 Uniclass codes, links below:

uniclass-2015

Uniclass 2015 Classification tables in CSV format

Uniclass 2015 Classification tables in CSV format

https://buildig.com/uniclass-2015/uniclass2015/Uniclass2015.csv

The top level includes 12 tables.

Each of these breaks down into Groups, Sub-groups, Sections, and Objects.

The tables have no entry for Groups, Sub-groups, Sections, and Objects.

The Groups have no entry for Sub-groups, Sections, and Objects.

Etc.

In the dataset there are multiple items with the same Group number for different tables, etc.

I would like to reorganize it so that so that each Group has a unique identifier, possibly the titie.

Would this best be achieved with a junction table?

[AB1-Airtable]

So I did it manually but it was pretty easy.

Filter out tables, copy, paste into new table

Filter out Groups, copy, paste into new table and link to Tables

Filter out Sub-groups, copy, paste into new table and link to Groups

Then link all Objects to Sub Groups and lookup rest of fields