Hello experts, I have been searching and searching for a solution and I can't get this to work. Like the title says I need a macro to select range separated by blank row and copy to next empty column. I'm really new to VBA so I need some help.

example:

DATE1 TIME1 MISC1
012313 17:03 0.0
012313 17:03 0.0
012313 17:03 0.0

DATE2 TIME2 MISC2
012313 17:03 0.0
012313 17:03 0.0
012313 17:03 0.0

DATE3 TIME3 MISC3
012313 17:03 0.0
012313 17:03 0.0
012313 17:03 0.0

Would like following result:

DATE1 TIME1 MISC1 DATE2 TIME2 MISC2 DATE3 TIME3 MISC3
012313 17:03 0.0 012313 17:03 0.0 012313 17:03 0.0
012313 17:03 0.0 012313 17:03 0.0 012313 17:03 0.0
012313 17:03 0.0 012313 17:03 0.0 012313 17:03 0.0

Basically transpose range to next available column. Is this doable?

Any help will be greatly appreciated...

Thanks