Splitting data against columns

Hi,

I have a dataset like the below table-A

Table-A

Sr. No. Feedbacks 10s 9s 8s 7s 6s 5s 4s 3s 2s 1s
1 10-18 9-8 6-1
2 10-26 9-16 8-1 6-1 5-1

I need a formula to split the data of Feedbacks like the below table-B

Table-B

Sr. No. Feedbacks 10s 9s 8s 7s 6s 5s 4s 3s 2s 1s
1 10-18 9-8 6-1 18 8 1
2 10-26 9-16 8-1 6-1 5-1 26 16 1 1 1

Please help

One way: Please try in C4 and copy down:

Formula:

Please Login or Register  to view this content.