Forum Discussion
Rearranging data in Access
I'm trying to input a large amount of data into Access, but instead of having one row for each result, the results are in a 2-dimensional grid, where each row represents a device being tested, each column represents a specific test, and a row-column combination results in the value from the test.
Is there a way in Access to shift all of the "values" data into the same column and then just identify each entry by its test ID?
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
