I think the key is your mock up. If you are able to reformat the original data into the format you used for your mock up data, I think your problem is solved. Do you have the ability to transform the original data? I can think of ways to automate that transformation using either SQL, Excel or other tools depending on the source of the data. I think coming up with a Tableau solution that makes use of the original data will probably be difficult if it is possible at all.
I was hoping that wasn't the case. But I already started transforming the data to fit the mock up. Thanks for the input!