Hi,
I have cell which contains C45-C90, I want it to split into multiple rows and fill in the form C45, C46,C47...C90
For example:
<tbody>
colA
ColB
C45-C50
0.6
C99-C101
0.5
</tbody>
Expected Result
<tbody>
Col A
Col B
Col C
C45
C45-C50
0.6
C46
0.6
C47
0.6
C48
0.6...