I have a table that has a clause number in the first column which is regular text and in the 2nd column there is sometimes a different number or letter but not always. need the identifier from column 2 to join with his brother in column 1. all are text a not number lists. Any help appreciated.
Current Table Rows 5.Requirements Computer Programs 5.1(a) identify extent which computer program conforms requirements Clauses 6 112 5.1a) analysis shutdown system effectiveness 5.2(i) change theoretical background 5.2i) change data structure 5.21) change programming language 5.21. change computer program structure 5.2(1). change computer program structure 5.2Note: change embedded data eg correlations
Required Table Rows 5.Requirements Computer Programs 5.1(a)identify extent which computer program conforms requirements Clauses 6 112 5.1 a)analysis shutdown system effectiveness 5.2(i)change theoretical background 5.2 i)change data structure 5.2 1)change programming language 5.2 1.change computer program structure 5.2(1).change computer program structure 5.2 Note:change embedded data eg correlations