Thanks for the info. However it is a large datebase with about 2000 entries
and multiple columns. I need to select every other row, cut them and then
paste them to a new list. Then collapse the empty rows on the original list.

"Lady Layla" wrote:

Is it a list in 1 column and you need to make it into 2 columns? If so,
Download Asap Utilities Add-in and use Advance Transposer -- select 2 columns
and let it go


"jont" wrote in message
...
: I need to divide a list I have in two equally. I want to do it by selecting
: every other one. Is ther a formula or macro I can use to do this?