Sorry, I really have no idea how to word this so haven't had any luck with google or searching here...

What I need is to be able to paste a whole bunch of data into a single cell, and then for it to be organised into columns and rows etc etc


For example, would it be possible to paste this;

John Harris 12ADHAD 12948124 Timmy Rogers 92OISJS 98752372 Jack Simmons 83IUHGA 9875291 Katie Something 98IAUSHF 38235928735 Smiley Face 82AOFSH 9823523

into the spreadsheet, and have automatically organised it into something nice and playable like this;

http://img238.imageshack.us/img238/5823/goodnr9.jpg



Is it possible?