OH! So you could do it with a pivot table. Nice to know.

My particular problem for which I used the code above also had
additional columns, such as annual total and code description values,
which were used in the For loop for some calculations.

On Oct 12, 1:05 pm, "Roger Govier" <rogerattechnology4NOSPAMu.co.uk
wrote:
Hi Low

You can do this utilising a method described by John Walkenbachhttp://www.j-walk.com/ss/excel/usertips/tip068.htm

--
Regards
Roger Govier

"Mr. Low" wrote in message

...



I have the following table :

Month
Code 1 2 3 4
5110 xxx
5111
5112
5113
5114

I would like to rearrange the table as

Code Month Amount
5110 1 xxx
5110 2 xxx
5110 3
5110 4
5111 1
5111 2
5111 3
5111 4
5112 1

Can I use the pivot table for this task ? Also it is possible to remove
the
Pivot Table Structure after rearranging ? I need to input the data in
large batches to another business system.

For the information, the Paste Special Transpose Data function does not
rearrange the data in the manner I wanted.

Thanks

Low

--
A36B58K641- Hide quoted text -

- Show quoted text -