1

I have an irregular table in Excel:

A A1 A2 A3
B B1
C C1 C2 C3 C4
...

How can I get the following its representation?

A A1
A A2
A A3
B B1
C C1
C C2
C C3
C C4
...
Community
  • 1
  • 1
Alex
  • 2,361
  • 1
  • 20
  • 27
  • A similar question: http://stackoverflow.com/questions/16722039/extract-categories-from-columns-into-duplicated-rows-with-new-category#comment24076827_16722039 – mr.Reband Dec 06 '13 at 14:52
  • A similar representation (not exactly the same) can be achieved by Paste Special --> Transpose – Pankaj Jaju Dec 06 '13 at 15:00

1 Answers1

1

This answer in SuperUser to Transform horizontal table layout to vertical table using VBA appears to give exactly what you are looking for.

The code is self explanatory by virtue of working step by step.

Hope it helps.

Community
  • 1
  • 1
sancho.s ReinstateMonicaCellio
  • 14,708
  • 20
  • 93
  • 185
  • That's practically what I want. The only thing what I fixed is the value of the first column. Suggested script fills it by 1, 2, ... instead of A, B, .... – Alex Dec 06 '13 at 17:40
  • 1
    @Alex - That is what I had posted in [a comment below the linked answer](http://superuser.com/questions/683413/transform-horizontal-table-layout-to-vertical-table/683439#comment866443_683439). Now I have incorporated it in the answer itself, so it probably has the same code as your answer. – sancho.s ReinstateMonicaCellio Dec 06 '13 at 18:02
  • yeah, now your solution is the same as mine and it completely solves my problem. – Alex Dec 06 '13 at 19:41