View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Cara Cara is offline
external usenet poster
 
Posts: 12
Default How do I make a column of data sort into rows?

I have a column of Titles sorted alphabetically from position A2 down to
A293. I would like to put it on another worksheet so that it is covering 3
columns yet still be alphabetical, i.e.; A2=alpha, B2=bravo, C2=charlie,
A3=delta, B3=echo, C3=fox-trot, A4=golf, etc. I have tried sorting left to
right, but it does nothing. Can someone please help?