I have data files that are in stanzas:
Item 1: Attribute 1 Item 2 Attibute 2 Item 3: Attr 3 Item 4: Attr 4
E.g. The following is a typical stanza.
This is difficult to work with. I want to normalize it so the items become column ids and the attributes become data, with 1 row per stanza. At that point chucking data I don't need becomes a lot easier.
This is possible in excel or google sheets but it requires some fairly messy lookups in each column, along with a ton of offsets. Doing in a way that is robust against slight changes in the orginal is even harder.
Does anyone know of an easier way to do this?