Sorting data

[Guest]

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.

 

[Guest]

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

Dave

 

[Guest]

Thank you, I wish it were that simple. I need to be able to sort the rows of
data into these 3 different columns. Can this be done by using 3 separate
sheets, one for each value(PT,OT, or ST)

 

[David McRitchie]

sounds like you could put the data into a Pivot Table
fine for doing things one time only, not so easy if you
want to do it on a regular basis.

or you could filter on one of those values, then copy
and paste to another sheet if you want to separate
the data into your three sheets, then repeat for the
other two values. Your will find more information
on Pivot Tables and on Filtering at

http://www.contextures.com/tiptech.html
http://www.datapigtechnologies.com/ExcelMain.htm