Perform UNPIVOT in Excel to import in Access

Asked

Viewed 135 times

1

I have a table with the following format:

Formato atual da tabela

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:

Formato Final da Tabela

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.

excel

  • What is your version of Excel? 2007, 2010... Ta em portugues, ingles, ..?

  • You have noticed that you have duplicate rows in your A column, for example: 685251, what to do in such cases?

  • 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.

  • 1

    This? http://office.microsoft.com/en-001/excel-help/unpivot-columns-HA104053356.aspx

  • I do not understand why they denied the question

1 answer

1


  • 1

    That’s right. Very orbgiado!

Browser other questions tagged excel

You are not signed in. Login or sign up in order to post.