ok, so I'm really screwed here. I have a table that is 23 Columns wide by 1578 Rows tall.
The column headers are

Asset Task Resolution 1 Resolutions 2 Resolution 3 etc up to resolution 21
with data like this
asset1 task 1 resolution1 resolution2 resolution3 etc up to however many resolutions that task has.
asset1 task 2 resolution 4 (if task 1 only had 3) resolution 5 etc....

Each Asset will have multiple rows for each task and each task has multiple columns of resolutions depending on how many resolutions there are.

I need to get this imported into an online database tool that wants it in this format:

Asset Task Resolution
with data from above example showing up like this assuming task 1 had 3 resolutions
asset1 task1 resolution1
asset1 task1 resolution2
asset1 task1 resolution3
asset1 task2 resolution4
asset1 task2 resolution5

Is there some sort of formula or script I could use to get this data translated into this format?