Making a list of data extracted from another excel file

Hello everyone! I have a Metars excel data (first image) here and I want to extract the data and make a list of it (second image). I have been doing it manually which I copy and paste the values from...