I have a table that has these first two columns, Number and Type. The second column 'Type' only will ever contain three different values "MC_STD, MC_BLK or MC_REP". I need to generate the third column, 'FormulaName' as shown. The data must be shown in it's correct Number order but the first Type shown as "STD 1.1". If that type is repeated later in the batch, it is to be shown as same std number with an incremental number.
Number Type FormulaName
1 MC_STD STD 1.1
2 MC_STD STD 1.2
3 MC_BLK STD 2.1
4 MC_STD STD 1.3
5 MC_REP STD 3.1
6 MC_BLK STD 2.2
7 MC_STD STD 1.4
8 MC_REP STD 3.2
Any ideas??????? Any help would be very much appreciated.
Thanks.
Number Type FormulaName
1 MC_STD STD 1.1
2 MC_STD STD 1.2
3 MC_BLK STD 2.1
4 MC_STD STD 1.3
5 MC_REP STD 3.1
6 MC_BLK STD 2.2
7 MC_STD STD 1.4
8 MC_REP STD 3.2
Any ideas??????? Any help would be very much appreciated.
Thanks.