[Redder Lurtz]

Originally Posted by wiiksie Thats just evil. No chance of getting Transpose to recognise that (even without the horrible feature of merging cells in the export). I think you need to write a function to iterate the cells, strip out individual items (column headers, data, anything merged etc) and then write it out in columns. Edit: lets see screeny to confirm its evil.

That's what I'm thinking Wiiksie. I'm all over Excel but I'm thinking I might have to do some VB stuff to make this work. I'm not up on Visual Basic at all although I recently bought a book about it. This exercise is leading me slowly but surely to the somewhat unfortunate conclusion that I am going to have to read it. Damn.