Cut And Paste Then Move TO The Cell Below.

[Gevaux19]

Hi,

I have a huge data file which goes across in different coloumns ie. Name - Address - Shares - Number - (Repeats across the screen)

I want to create a macro which can convert 4 coloumns at a time so it would look like:

Name -Address - Shares - Number
Name -Address - Shares - Number
(Onwards).

Please Help!

Thanks

Matt