Ampleford
Active Member
- Joined
- Mar 26, 2002
- Messages
- 380
Hi there, We have a system that issues tabled data which appears in the following format:-
Column A | Column B
Level | Description
Top Level | Top Level Description
(2 "spaces") 2nd Level Code |(2 "spaces") 2nd Level Description
(4 "spaces") 3rd Level Code | (4 "spaces") 3rd Level Description
The levels can be up to 10/12 deep, with some having all levels, some having only one higher level.
looking into the cells, it looks like the data is tabulated and not spaced as in my example above. I'd like to convert these two columns into multiple columns (moving to the right with each level) to make review / lookup etc much easier
Can anyone help?
Column A | Column B
Level | Description
Top Level | Top Level Description
(2 "spaces") 2nd Level Code |(2 "spaces") 2nd Level Description
(4 "spaces") 3rd Level Code | (4 "spaces") 3rd Level Description
The levels can be up to 10/12 deep, with some having all levels, some having only one higher level.
looking into the cells, it looks like the data is tabulated and not spaced as in my example above. I'd like to convert these two columns into multiple columns (moving to the right with each level) to make review / lookup etc much easier
Can anyone help?
