Thanks Keith, Getting closer I have the table in access now but I can not find a transpose wizard, any chance you could point me to where I can find it Thanks Rob