Forum Discussion
Rearranging data in Access
jamesson_kaupanger I can't say that its crystal clear what you are after but I think you are out for transposing "rows" to "columns"..
Just load the data in a recordset...iterate the fields on each record and .AddNew/.Edit accordingly.
I don't know how I missed this reply...
Sort of: I want to go from columns to column. In other words: if I have 4 sites and I'm running 5 tests on each of those sites, that's 20 total test results. Currently, the data is laid out in a 4 x 5 grid. I want to transpose that to a 20 x 1 grid, making the results all in one column.
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
Here's a simplified example of what the data looks like:
Each Excel file represents one lot
Each lot has several samples
Each sample has ~30 sites being tested
Each site is tested with up to 300 tests.
