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

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

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)
--
Thank you,

Todd Smith


"Dave F" wrote:

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

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

---
HTH,
David McRitchie, Microsoft MVP - Excel
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"activtodd" wrote in message ...
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)
--
Thank you,

Todd Smith


"Dave F" wrote:

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