Move data to new row after each empty column

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

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

--

Originally Posted by [email protected]

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