It's easy to do what you want, I think, but I don't know what you have nor
what you want to have. Your explanation of what you have is not clear. Is
it that you have repeating columns of 3 and you want all of the data put
into 3 columns total? Post back and provide some examples of what you have.
HTH Otto














"Mac" wrote in message
...
I need help. i have a worksheet that is set up in columns like:
id acct no amount
I have 250 rows of data and a lots of columns
Whiat I would like to do is set it up so that the rows look like this
id account amount
for all.
is there a way to do a macro that will take all the data by column and
move
it to a row and continue without overwriting the data?

Any help will be greatly appreciated