I have text file like following:
NAME: Mike
price: $12
UNIT: 3
NAME: Tom
price: $12
UNIT: 3
NAME: SMITH
PRICE: $16
UNIT: 6
NAME: Jone
price: $22
UNIT: 3
NAME: Yang
price: $32
UNIT: 5
NAME: Yubin
PRICE: $6
UNIT: 10

How to switch to Excel file like following style?

NAME price UNIT
Mike $12 3
Tom $12 3
SMITH $16 6
Jone $22 3
Yang $32 5
Yubin $6 10

thank you!