Hello Roger,

Thanks for the tip and many other helpful resources at the website.

Regards,

Low


--
A36B58K641


"Roger Govier" wrote:

Hi Low

You can do this utilising a method described by John Walkenbach
http://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