Thread: Text Columns to Rows
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Herbert Seidenberg Herbert Seidenberg is offline
external usenet poster
  
Posts: 1,180
Default Text Columns to Rows
You *can* use pivot table.
You just have to convert PT to List
with a bit of VBA.
Excel 2003.
http://www.freefilehosting.net/download/3b61d
Reply With QuoteReply With Quote