Can someone pls help with the following data. currently my data is as below in the first table. How can i get it to split by column 0 values so as to get it as in the table 2.
Both table has 8 columns.
Thanks.Any leads will be appreciated.
| Column0 | Column1 | Column2 | Column3 | Column01 | Column12 | Column23 | Column34 |
| A | test1 | test2 | test3 | C | test1 | test2 | test3 |
| A | test1 | test2 | test3 | C | test1 | test2 | test3 |
| A | test1 | test2 | test3 | C | test1 | test2 | test3 |
| A | test1 | test2 | test3 | C | test1 | test2 | test3 |
| B | test1 | test2 | test3 | C | test1 | test2 | test3 |
| B | test1 | test2 | test3 | C | test1 | test2 | test3 |
| B | test1 | test2 | test3 | C | test1 | test2 | test3 |
| C | test1 | test2 | test3 | C | test1 | test2 | test3 |
| C | test1 | test2 | test3 | C | test1 | test2 | test3 |
| Column0 | Column1 | Column2 | Column3 | Column01 | Column12 | Column23 | Column34 |
| A | test1 | test2 | test3 | A | test1 | test2 | test3 |
| A | test1 | test2 | test3 | A | test1 | test2 | test3 |
| B | test1 | test2 | test3 | B | test1 | test2 | test3 |
| B | test1 | test2 | test3 | Null | Null | Null | Null |
| C | test1 | test2 | test3 | C | test1 | test2 | test3 |
| C | test1 | test2 | test3 | C | test1 | test2 | test3 |
| C | test1 | test2 | test3 | C | test1 | test2 | test3 |
| C | test1 | test2 | test3 | C | test1 | test2 | test3 |
| C | test1 | test2 | test3 | C | test1 | test2 | test3 |
| C | test1 | test2 | test3 | Null | Null | Null | Null |
It's probably just me but I'm not seeing what the conversion rules are for this.