Continue a Column to the next Column

W

wayne in oregon

I have a spreadsheet with many short column except one column is very long.
How can I make the long column into two shorter columns and have them stay
connected, be seen as the same column of data. Once you get to the bottom of
the first column it needs to jump to the top of the next column.
 
G

Gord Dibben

Just a caveat here Wayne.

The column split into two columns will not still be seen as "connected" or
"same column of data".

It will be two distinct columns.

Gord Dibben Excel MVP

Hi Wayne,
See my snake columns page
http://www.mvps.org/dmcritchie/excel/snakecol.htm
--
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

wayne in oregon said:
I have a spreadsheet with many short column except one column is very long.
How can I make the long column into two shorter columns and have them stay
connected, be seen as the same column of data. Once you get to the bottom of
the first column it needs to jump to the top of the next column.
Click to expand...
Click to expand...
 
Top