Excel 2007 : how to get columise data out of raw data

[mailview]

Hi
I have a sheet 1 with raw data such as bellow

Date Day Time Number Place Duration Cost

08/04/10 Thu 13:55 07967408575 0:02:47 0.000
From a website and now what i want to do to make a excel sheet where if in sheet 1 i insert the raw data in to one for example in A 1

then in sheet 2 is should appears as in colums sepratly raher then just a raw data

see the attachment
please help