Excel formula to auto -populate data from a raw file

Good day everyone, I'm just a newbie here and don't know much about the excel formula.

Any advise, tips and tricks regarding to how to auto-populate a certain cell with same name but also have different data. I just attached here my sample as I input it manually. Thanks and hope I can get good result. Thanks everyone.