Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
text parsing/table creation from single column data
Hi:
have problem: tab delimited text files, repeating blocks of text separated by two tabs, which I need to convert to a table format. The text imports as a single column, the data occurring in blocks of twenty-eight cells separated by two blank cells. Need to parse, and transpose these blocks of cells to create a table of twenty eight columns I can manipulate. I can do the copy/transpose function from the toolbar for short files, but some of these files will have hundreds of rows, not something I want to do by hand. Is there aformulae/macro/template which will perform this function? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
text parsing/table creation from single column data
Select your column of data and then click DATA on the menu and select TEXT TO
COLUMNS and select TAB as the delimiter and all the data will be automatically parsed to columns. -- Kevin Backmann "cruiser" wrote: Hi: have problem: tab delimited text files, repeating blocks of text separated by two tabs, which I need to convert to a table format. The text imports as a single column, the data occurring in blocks of twenty-eight cells separated by two blank cells. Need to parse, and transpose these blocks of cells to create a table of twenty eight columns I can manipulate. I can do the copy/transpose function from the toolbar for short files, but some of these files will have hundreds of rows, not something I want to do by hand. Is there aformulae/macro/template which will perform this function? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pivot table column creation: Mission Impossible ? | Excel Discussion (Misc queries) | |||
parsing text in a multiple column count | Excel Worksheet Functions | |||
Creating single lines of data from a multi-column table | Excel Discussion (Misc queries) | |||
Parsing Data with Formulas (vs Text-to-Columns) | Excel Worksheet Functions | |||
VBA Import of text file & Array parsing of that data | Excel Discussion (Misc queries) |