I am trying to write a macro that will go through a column and create a row from 4 cells. For Example A1, A2 ,A3, A4 creates A1, B1, C1 and D1 ... A5, A6, A7, A8 Creates A2, B2, C3 and D2. This will continue until there is no more data in Column A. The data itself is a mixture of text, numbers and email addresses.
Any Help would be great!