Somehow I don't think what I recommended is going to work? Upon reflection
you say that the information in the column is repeated, and that means that
there are going to be duplicate entries grouped together. Which means many
entries in row 1 are going to be the same also.

Ok, I'll bite - send the workbook to 2kmaro @ dslr.net (remove spaces) and
maybe some more explanation and I'll work up some code to do the job. Expect
a day or two delay on response. Maybe someone will come up with already
written code or wild function to do the job before then.

"Jan" wrote:

In an excel worksheet, I have repeated data in column 1. Now I want to sort
it and make the data in column 1 the headers. Difficult to explain, but if I
can send you my excel sheet you will understand it right away.....
Hope somebody can help.....
Jan Wind