Transposing list and repeating occurrences..

Hi
I have a list as follows..

May-10 June - 10 July - 10 Aug-10 Sep- 10
123455 0 12 24 34 12
123456 19 23 34 0 120
123457 22 78 34 0 123


But I want to format the list to look like this...

Part number Amount
123455 0
123455 12
123455 24
123455 34
123455 12
123456 19
123456 23
123456 34
123456 0
123456 120

Ideally, I'd like to be able to do it with a macro. The headings across the top will probably vary...(could be 9 or 12 months)...so what I want Excel to do is copy down the part numbers as frequently as the number of columns across the top i.e. if there are 14 dates across the top...that it would copy down each part number that often..

Thanks a million..
Anne

Hi,
don't ask me how it works but here is a fast and elegant solution -Good luck

Hi
Thanks for this...but am using excel 2007 and it's not working for me...I can't get the part numbers to repeat the way the account numbers did in the example...anything else you think I should look at??
Anne

Hi
how could I do the following...(using the sheet above)

Copy a part number from another sheet...then count the entries in a row going across e.g. May-10, June-10 etc say I get 10. Then copy down the part number so that it repeats 10 times (equal to the number of entries), and then to do that for all the other part numbers I have?
Thanks!
Anne

Originally Posted by abalserv

Hi
Thanks for this...but am using excel 2007 and it's not working for me...I can't get the part numbers to repeat the way the account numbers did in the example...anything else you think I should look at??
Anne

Hi,
if you are using 2007 please adapt your profile accordingly. it states 2003 - Thx

Hi
This worked beautifully...thank you very much!