Format excel data

Hello,

i need to modify the data in my excel. Right now the data looks something like this:

case A
start 51
stop 55
count 1

case B
start 54
stop 67
Count 2


I need it to look like this:


case start stop count
A 51 55 1
B 54 67 2


Please help!