I have a table with the following format:
Asthefirstcolumnandthefirstrowarecodefields,IneedtobeinthefollowingformatforimportintoMSAccess:
It is possible to do it manually, but since the table is VERY extensive, I wonder if you have any way to do this automatically? This would save me a good 3 days of work.
Excel is the 2010 en-US version. Access is 2003, also in Portuguese. On the lines with the same code, just ignore, because it was an example that I created and did not change, all the codes are unique in the real table.