I have an excel spreadsheet with 6 column titles as follows:
1st column title = ob1
2nd column title = ob2
3rd column title = ab1
4th column title = ob3
5th column title = ab2
6th column title = ob4

I have about 200 lines of information on each column. I want to run a macro
/ function on this spreadsheet and my spreadsheet should regroup similar
titles together as follows:

1st column title = ob1
2nd column title = ob2
3rd column title = ob3
4th column title = ob4
<blank column
5th column title = ab1
6th column title = ab2

Can someone think of any way to do this? (A macro solution would be
preferable)

P.S. I have about 16 column titles that I need to group in my excel file.
For simplicity sake, I have explained my problem with 6 columns.

Have you tried to sort them, using the option "from left to right"?
You could use a dummy row to set the required order.
--
Greetings from New Zealand
Bill K

"vrk1" wrote in message
...
I have an excel spreadsheet with 6 column titles as follows:
1st column title = ob1
2nd column title = ob2
3rd column title = ab1
4th column title = ob3
5th column title = ab2
6th column title = ob4

I have about 200 lines of information on each column. I want to run a
macro
/ function on this spreadsheet and my spreadsheet should regroup similar
titles together as follows:

1st column title = ob1
2nd column title = ob2
3rd column title = ob3
4th column title = ob4
<blank column
5th column title = ab1
6th column title = ab2

Can someone think of any way to do this? (A macro solution would be
preferable)

P.S. I have about 16 column titles that I need to group in my excel file.
For simplicity sake, I have explained my problem with 6 columns.

Thank you. That resolved my problem!

"Bill Kuunders" wrote:

Have you tried to sort them, using the option "from left to right"?
You could use a dummy row to set the required order.
--
Greetings from New Zealand
Bill K

"vrk1" wrote in message
...
I have an excel spreadsheet with 6 column titles as follows:
1st column title = ob1
2nd column title = ob2
3rd column title = ab1
4th column title = ob3
5th column title = ab2
6th column title = ob4

I have about 200 lines of information on each column. I want to run a
macro
/ function on this spreadsheet and my spreadsheet should regroup similar
titles together as follows:

1st column title = ob1
2nd column title = ob2
3rd column title = ob3
4th column title = ob4
<blank column
5th column title = ab1
6th column title = ab2

Can someone think of any way to do this? (A macro solution would be
preferable)

P.S. I have about 16 column titles that I need to group in my excel file.
For simplicity sake, I have explained my problem with 6 columns.