How can I take multiple columns and create new rows based on the data?
We input some data through a form that is very limited in how it organizes the data. It currently looks similar to this (these are the column headers):
Date / Manager / State / District / Site / Type of Inspection / 1 - Category of Violation / 1 - Violation / 1 - Plan of Correction / 2 - (same 3 column titles) / 3 - (same) / up to 10
I'd like to be able to use the data in a way where the data resembles this...
Date/Manager/State/District/Site/Type of Inspection / 1- Category / 1 Violation / 1 Plan of Correction
Date/Manager/State/District/Site/Type of Inspection / 2- Category / 2 Violation / 2 Plan of Correction
---and so on
The thought being I can then create cards that categorize all category violations in charts with drill paths to the other data (pie chart of categories of violations). I feel like I should be able to use maybe collapse/uncollapse but my efforts have been comical at best.
Any thoughts? Thanks for the help.