| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
formating bad records in table format
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!!  -- hasn7 ------------------------------------------------------------------------ hasn7's Profile: http://www.excelforum.com/member.php...o&userid=34577 View this thread: http://www.excelforum.com/showthread...hreadid=543479 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| PIVOT TABLE - hiding records with CALCULATED item values equal to | Excel Discussion (Misc queries) | |||
| How do I number format the Data Table in an Excel Chart? | Charts and Charting in Excel | |||
| Format a column in a table based on the date | Excel Discussion (Misc queries) | |||
| pivot table sort entries that don't yet appear in table | Excel Discussion (Misc queries) | |||
| Conditional Formating - not in table | Excel Worksheet Functions | |||
Threaded Mode
