Move data to new row after each empty column

[feedmegold]

Hi all!

I have copied some addresses into excel from a word document with a
transposed paste.
So after each set of data there is an empty column. I was wondering
whether there was an automated way of moving the data to the right of
the empty column onto a new row and continuing for every empty column
that appears.

I hope someone can help.

Thanks

Stef

 

[Bryan Hessey]

Notwithstanding that you may have had a reason to do a transposed paste
from Word, is the format of your data now a number of rows per data
set? or a single row and a number of columns per set?

Is the blank column a column? or does the blank appear in different
columns depending upon the number of items to the set?
Does the set to the right need to be on the next row, or can it be
added to the bottom of the data in column A?

If the blank column is a column, say you have a 'set' in columns A to
E, and column F is blank, and sets in columns G to K, column L is
blank, sets in columns M to Q etc. and that the data can be added to
the bottom.
Select the rows in columns G to K (note do not select whole columns,
just a single select from G1 to K999 etc) and CUT. Then select the next
line after the data in column A, and Paste. Repeat for columns M to Q
etc.

If it is neccassary to insert on the following row, and if you wish to
avoid VB code, please let me know.

Hope this helps

--