I tried the Copy using [Ctrl][C][C] but with no joy. All it seemed to do was eliminate the spaces between the data in the column i.e. they appeared bunched up in the column rather that spaced out as shown in my example above.
I also re-tried to fix it using the DATA tab. Still wouldn't put things in the right order.
I've also looked to see if HSBC offers a 'Download Transactions' facility, but they don't. It's so frustrating to have been able to do this for so long... and then get a problem with Excel 2007! I know it'd not my statement that's changed as i tried it on my father-in-laws PC with Excel 2003 and it's fine. I know i could copy and paste it onto his Excel 2003 then email it to myself, but this work around isn't practical.
As for the Transposed solution... i'm not that clued up on what that actually means!
Thanks for all the advise guys - maybe something will come up!