formating bad records in table format

H

hasn7

I want to organize data into table format. the data I have on file is
not formated and has multiple information in single record field, and
info go on to multiple rows, for example:
customer name: abc age:x address: 123 all in one cell, no comma btw
those records, there is space btw those records but not consistent,
there are 1000 of those customers.
i want to display this data in table format having fields like
name,address, age,etc with info stored in rows and columns.
Can somebody help!!
:confused:
 
Top