Hi!
Thanks in advance for any advice. I am a relative novice stuck at a
crossroads and really appreciate any help.

I've created a spreadsheet that spits out the information I need
organized in the following format:

.. A - B - C - D - E - F - G - H - I - J - K - L .....
1 X X X X
2 X X X X
3 X X X X
4 X X X X
5 X X X X
6 X X X X
____________________________

This means that, on any given row, there are 4 (and only 4) columns
containing information - and the rest of the cells are blank.

Now I need to know how to consolidate this information so that it is
all contained in one set of columns (eg):

.. A - B - C - D
1 X X X X
2 X X X X
3 X X X X
4 X X X X
5 X X X X
6 X X X X
_____________________________

Like I said, I have it set up so that, on every single row, there are
exactly 4 consecutive cells containing info. I have also made sure
that there will be no blank rows to deal with (every row WILL contain 4
cells of info). However, the placement of those 4 cells along the X
axis varies from row to row (sometimes it is in cells A-D, and
sometimes in cells CH-CK, etc).

In simple terms, I need to just end up with a sheet containing only 4
columns of data, no more.

I never realized how hard it was to explain a spreadsheet! Hopefully I
made some sense, and someone out there will have some advice. Let me
know if there are any details I need to add that I've forgotten. Thx
again!