[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.