I always get it in two columns from NatWest! Although I dont go for csv format so that might have something to do with it.
What is it you are trying to do - as in, I mean, why do you need it in two columns? Is it just so its easier to see? If so - what about conditional formatting?
__________________
Joanne
Winner of Bookkeeper of the Year 2015, 2016 & 2017
Thoughts are my own/not to be regarded as official advice,which should be sought from a suitably qualified Accountant.
You should check out answers with reference to the legal position
Having glanced at this thread just before I happened to need to log in to a Natwest account, I downloaded a CSV 'bank statement' out of curiosity - there were debit and credit columns, so payments and receipts were already separated as I'd expect.
I'm therefore a little confused by what the OP was trying to achieve - what was the purpose of the CSV download, and why did you want the payments and receipts separated? (And in what way - did you want them in separate files, for example?)
__________________
Vince M Hudd - Soft Rock Software
(I only came here looking for fellow apiarists...)