Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Data parsing question
I've got a set of data in the following format (extra linebreak between rows
to avoid wrapping ambiguities): Label1:current/max Label3:current/max Label8:current/max Label1:current/max Labe2:current/max Label11:current/max Label3:current/max Label4:current/max Label68:current/max label71:current/max .... The labels are text strings, possibly with spaces, and in a consistant order with no space for empty/nonexistant labels. Outside the labels three aren't any spaces in the tags strings whick are 1/cell. There're upto ~20 triplets per line, and almost 4000 total lines. I want to break out into additional columns with the original order maintained, the lables in every second row of an initial header, current/max as 2nd row headers below every label and the two values in thier own columns. Like this (The table's formated for a fixedwiidth font with X's added to mark empty cells): Label1 X label2 X Label3 X Lable4 X ...... Cur Max Cur Max Cur Max Cur Max ...... N1 N2 X X N1 N2 X X ...... N1 N2 N1 N2 X X X X ...... X X X X N1 N2 N1 N2 ...... |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Line Graph Data Recognition | Charts and Charting in Excel | |||
Copying conditional formatting...HELP PLEASE!!!! | Excel Worksheet Functions | |||
autofill question | Excel Discussion (Misc queries) | |||
Validation Data & Goto question | Excel Discussion (Misc queries) | |||
Data Table Question | Charts and Charting in Excel |