Read Multiple values from Notepad and convert into excel

I have extracted the values from PDF using OCR.
I want extract the values from notepad and put into excel .

Can anybody help me.

Input -

Invoice Date : 10 Aug 2019

Datta Technology India Limited Invoice No : 001527734


Hotel Xyz| 139 | 160

Hotel Abc| 179 | 180

Out Put -
Coulmns in excel with values
Invoice date , Invoice No, Hotel Name , Price1 and Price 2


Welcome to our community!

All the files will be in the same format as you shared here or any different formats/extra lines would be there?

Extra line would be there for hotels or some extra line would be there