I have many columns in my table, and want to find out the first not null data cell in these columns, and pick it out into a new column. Someone knows how to do it? As below table, the starting number is wanted result.
| Name | no.1 | no.2 | no.3 | no.4 | no.5 | the starting number |
| a | 1 | 2 | 3 | 4 | 5 | 1 |
| b | | 2 | 3 | 4 | 5 | 2 |
| c | | | 3 | 4 | 5 | 3 |
| d | | | | 4 | 5 | 4 |
| e | 1 | 2 | 3 | 4 | 5 | 1 |
| f | 1 | | 3 | 4 | 5 | 1 |
| g | 1 | | | 4 | 5 | 1 |
