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