Move data from three rows to one row.

[mike72688]

Hi,

I have data which is formatted into rows 1,2,3 and I want all the data to be in row 1. So I want to move the data in row 2 up and over into row 1 and then repeat for row 3. Then I need to continue repeating this for rows 5,6,7 then 9,10,11, etc. until the bottom of my data is reached. My attachment (Before.jpg) is and example of how my data would look now. The second attachment (After.jpg) show how I would want it to be formatted. I am not a coder, so if I have to create a module or something please let me know. Thanks in advance for your help.

[tigeravatar]

mike72688,

Attached is a sample workbook with a button assigned to the following macro:

Please Login or Register  to view this content.

Hope this helps,
~tigeravatar

[mike72688]

Thanks. I see your example works. How can I get that button into my spreadsheet?