View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
[email protected] tr2usa@yahoo.com is offline
external usenet poster
 
Posts: 11
Default Reversing date from column to Row

I need to change data from this format
ItemNo PCAL PCBW PCCH
PH53015 43 43 16

to this format.
Item Code Value
PH53015 PCAL 43
PH53015 PCBW 43
PH53015 PCCH 16

Can some one help me out?

Thanks