View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
CW CW is offline
external usenet poster
 
Posts: 54
Default Convert a Column into a Row

Copy - Paste Special - Transpose
The count if function would work for your second question

"Thansal" wrote:

I have (in one worksheet) a list of all Majors.
I now want to convert that column into my header row for another
worksheet.

The final step would be to search through 3 rows in a 3rd worksheet and
count each time a specific major occurs (if I could automate this so
the formula simply looks at header for it's column and then searches
for that It would be perfect).

Thank you for any help you can offer me.

AlexV