I have a .txt file from monitoring data.
it comes in following format
Example:
3,673,49,2,43,89,8,138,45,9,49,675 etc.
1) The data is in groups of 3 .. but comes as ONE string with commas.
2) 2nd number has a reference table for description in another Excel table
Say:
673 | RRRRR
43 | YYY
138 | GFR
need .txt to open in this format
Cell A Cell B Cell C Cell D
1 3 RRRRR 49
2 2 YYY 89
3 8 GFR 45
and so on.
Some guidance on how this is done would be great.
it comes in following format
Example:
3,673,49,2,43,89,8,138,45,9,49,675 etc.
1) The data is in groups of 3 .. but comes as ONE string with commas.
2) 2nd number has a reference table for description in another Excel table
Say:
673 | RRRRR
43 | YYY
138 | GFR
need .txt to open in this format
Cell A Cell B Cell C Cell D
1 3 RRRRR 49
2 2 YYY 89
3 8 GFR 45
and so on.
Some guidance on how this is done would be great.
