Quote Originally Posted by Ecniv
Hi,

Doesn't work because the pivot table I will run from it reads the source data - and gives separate lines.

Turns out the formatting on the cells was waht was messing me up ... Reset back to general and the correct data appeared.

Sorry to have posted a waste of time post
You never mentioned that the pivot table was involved in this. In your post you just mentioned that you copied the data from access. I was under that impresssion and hence I suggested that way.

Anyways. Glad it is resolved.