Forum Discussion
Rearranging data in Access
jamesson_kaupanger As i said...load the data on a recordset...iterate it and use it to populate a table with the shape you want.
Probably some sample data will make things clearer
I'll experiment with that and get back to you.
On a related note, I've since learned that Excel's "Unpivot" function is precisely what I'm trying to do. The problem is that it relies on the user creating a Query. I need this tool to be able to be used by people that do not have an intimate understand of Excel's inner workings. When I tried to implement the function through VBA, the result was very convoluted and dependent on the specific data there; I don't know how to create a generic query for whatever tests might be across the top of this file. Do you have any insight in that realm?