1
I have a table with the following format:
As the first column and the first row are code fields, I need it to be in the following format, for import in MS Access:
It is possible to do it manually, but since the table is VERY extensive, I wonder if you have any way to do it automatically? That would save me a good three days' work.
Excel is version 2010 en-BR. Access is version 2003, also in Portuguese. On the lines with the same code, just ignore, because it was an example that I created and ended up not changing, all codes are unique in the real table.
What is your version of Excel? 2007, 2010... Ta em portugues, ingles, ..?
– Math
You have noticed that you have duplicate rows in your A column, for example:
685251, what to do in such cases?– Math
Hello, about duplicate lines, I created as an example only, but the keys will all be different. It was something I missed. Excel 2010 in Portuguese.
– Felipe Deguchi
This? http://office.microsoft.com/en-001/excel-help/unpivot-columns-HA104053356.aspx
– bfavaretto
I do not understand why they denied the question
– gmsantos