I have the data in excel of medical but facing prolblem to sort or correct
data shape is like this

OPD No, Employee No. Name of Medicine. Prescribed by. quantity. price
1 0001 Dr ABC
Panadol
10 20
abc
1 30
ccc
2 3

the data consist more the 18800 rows and 6 col but i need in following shape
i need ur help to save my time rather then deleted and copying the same data
its more then 3 days work

OPD No, Employee No. Name of Medicine. Prescribed by. quantity. price
1 0001 Panadol Dr. ABC
10 20
1 0001 abc Dr. ABC
1 30
1 0001 ccc Dr. ABC
2 3