Press F1 and look up the Excel Help files on the TRANSPOSE feature.

--
"Actually, I *am* a rocket scientist." -- JB

Your feedback is appreciated, click YES if this post helped you.


"silentpro" wrote:

Lets say I have a column labeled Name in column C

If the values in column C always begin with 1, 2, 3, etc..., is there anyway
to extract those values & make column headers out of them?

The next thing would then be to get the data in column D that correlates to
C...
Example if I can create new columns of 1, 2, & 3.
Then I would want to display all the data that would be in col D next to a 1
in C under the new 1 column....did I loose anyone..???


Thanks