ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   text parsing_table creation for single column (https://www.excelbanter.com/excel-programming/399864-text-parsing_table-creation-single-column.html)

cruiser

text parsing_table creation for single column
 
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 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 a formulae/macro/template
which will perform this function?



All times are GMT +1. The time now is 10:50 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com