View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Calvin Calvin is offline
external usenet poster
 
Posts: 14
Default copying multiple rows to columns

i need to copy every 4th row and put it in its own column while using the
first row in each new column as its name. eg.

pepole fruit
boy apple
girl pear
man mango
fruit
apple
pear
mango