Not often we get a request to 'unshape' data!! There are a few ways to go about this. Probably the easiest is to use an Excel Pivot Table.
If you look at the attached, I've taken some dummy (year across data), shaped it using the Tableau Excel Add-in, then changed it back by creating a Pivot Table. Hope that helps
Unshape Data.xlsx 13.2 KB
Many thanks for your reply - appreciate the odd nature of the request and this has helped alot,