Thread: Sorting data
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Dave F Dave F is offline
external usenet poster
 
Posts: 2,574
Default Sorting data

Select the column of data you want to turn into column headings, copy it,
select a destination cell, right-click, paste special, transpose.

Dave
--
Brevity is the soul of wit.


"activtodd" wrote:

Is it possible to create columns using data from a single column? I have four
columns of data. The fourth column of each row contains of one of three
different values(PT,OT,ST). I would like to use these values as column
headings to sort the rows of information.
--
Thank you,

Todd Smith