Hi have a data which look like this.
Column1 | Column2 |
AB1 | X1 |
AB1 | X2 |
AB1 | X3 |
AB1 | X4 |
AB1 | X5 |
AB1 | X6 |
CD1 | S1 |
CD1 | S2 |
CD1 | S3 |
CD1 | S4 |
CD1 | S5 |
CD1 | S6 |
CD1 | S7 |
CD1 | S8 |
CD1 | S9 |
EF1 | P1 |
EF1 | P2 |
EF1 | P3 |
EF1 | P4 |
EF1 | P1 |
EF1 | P2 |
EF1 | P3 |
EF1 | P4 |
GH5 | j1 |
GH5 | j2 |
GH5 | j3 |
GH5 | j4 |
And I want to create output column using Column1 and Column2 like below
Output Column | Column1 | Column2 |
Updated Asumption 1 | AB1 | X1 |
Updated Asumption 1 | AB1 | X2 |
Updated Asumption 1 | AB1 | X3 |
Updated Asumption 1 | AB1 | X4 |
Updated Asumption 1 | AB1 | X5 |
Updated Asumption 1 | AB1 | X6 |
Updated Asumption 2 | CD1 | S1 |
Updated Asumption 2 | CD1 | S2 |
Updated Asumption 2 | CD1 | S3 |
Updated Asumption 2 | CD1 | S4 |
Updated Asumption 2 | CD1 | S5 |
Updated Asumption 2 | CD1 | S6 |
Updated Asumption 2 | CD1 | S7 |
Updated Asumption 2 | CD1 | S8 |
Updated Asumption 2 | CD1 | S9 |
Updated Asumption 3 | EF1 | P1 |
Updated Asumption 3 | EF1 | P2 |
Updated Asumption 3 | EF1 | P3 |
Updated Asumption 3 | EF1 | P4 |
Updated Asumption 4 | EF1 | P1 |
Updated Asumption 4 | EF1 | P2 |
Updated Asumption 4 | EF1 | P3 |
Updated Asumption 4 | EF1 | P4 |
Updated Asumption 5 | GH5 | j1 |
Updated Asumption 5 | GH5 | j2 |
Updated Asumption 5 | GH5 | j3 |
Updated Asumption 5 | GH5 | j4 |