Ken Johnson wrote:
Ghosty wrote:
Hi Ken,

Thanks a bunch that worked out great!

For some strange reason it popped a few records even further to the
right of the newly transposed data any ideas why?

Hi Ghosty,

Is it possible that the blank cell separating each group of records was
missing for those strange results?

That's all I can think of. The code I composed definitely relied on
that single blank cell separating the different groups.

Ken Johnson

Thanks a bunch you're a true excel guru! I tried it again with another
large batch of data and I think it may have been a missing blank row