Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Managing bad data
I want to organize data into table format. the data I have on csv file is not formated and has multiple information in single record field, and info go on to multiple rows, for example: NAME: abc AGE:x ADDRESS: 123 all this info is in one cell, no comma btw the info, there is space but its not consistent, there are 1000 of those customers.Some customer info cover multiple lines. i want to display this data in table format having fields like name,address, age with info stored in rows and columns. Can somebody help!! -- hasn7 ------------------------------------------------------------------------ hasn7's Profile: http://www.excelforum.com/member.php...o&userid=34577 View this thread: http://www.excelforum.com/showthread...hreadid=543495 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pull data from another sheet based on certain criteria | Excel Discussion (Misc queries) | |||
Importing Data | Excel Worksheet Functions | |||
Help PLEASE! Not sure what answer is: Match? Index? Other? | Excel Worksheet Functions | |||
Saving data in a worksheet within a workbook | Excel Discussion (Misc queries) | |||
Line Graph Data Recognition | Charts and Charting in Excel |