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?

It's not big deal though since it only did that to 5 out of 1000
"records"

Thanks again.