Making a list of data extracted from another excel file

%3CLINGO-SUB%20id%3D%22lingo-sub-1410974%22%20slang%3D%22en-US%22%3EMaking%20a%20list%20of%20data%20extracted%20from%20another%20excel%20file%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1410974%22%20slang%3D%22en-US%22%3E%3CP%3EHello%20everyone!%20I%20have%20a%20Metars%20excel%20data%20(first%20image)%20here%20and%20I%20want%20to%20extract%20the%20data%20and%20make%20a%20list%20of%20it%20(second%20image).%20I%20have%20been%20doing%20it%20manually%20which%20I%20copy%20and%20paste%20the%20values%20from%20the%20files%20to%20another%20excel%20table%20which%20is%20I%20think%20is%20very%20time-consuming.%26nbsp%3B%20Is%20there%20anybody%20know%20how%20to%20make%20it%20more%20automatic%20so%20that%20I%20don't%20have%20to%20copy%20and%20paste%20all%20the%20time.%20Thank%20you%20for%20helping%20me.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-center%22%20image-alt%3D%22EXCEL%201.PNG%22%20style%3D%22width%3A%20677px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F193817i088BE15D1F3190CC%2Fimage-dimensions%2F677x367%3Fv%3D1.0%22%20width%3D%22677%22%20height%3D%22367%22%20title%3D%22EXCEL%201.PNG%22%20alt%3D%22EXCEL%201.PNG%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22EXCEL%202.PNG%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F193827i78939E7449D03614%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20title%3D%22EXCEL%202.PNG%22%20alt%3D%22EXCEL%202.PNG%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1410974%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EBI%20%26amp%3B%20Data%20Analysis%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%20for%20web%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%20on%20Mac%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%20on%20mobile%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1411116%22%20slang%3D%22en-US%22%3ERe%3A%20Making%20a%20list%20of%20data%20extracted%20from%20another%20excel%20file%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1411116%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F676599%22%20target%3D%22_blank%22%3E%40Ashraf34%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EIt%20looks%20like%20a%20job%20for%20Power%20Query%2C%20you%20may%20dig%20in%20this%20direction.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Occasional Visitor

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 the files to another excel table which is I think is very time-consuming.  Is there anybody know how to make it more automatic so that I don't have to copy and paste all the time. Thank you for helping me. 

 

 

EXCEL 1.PNG

 

EXCEL 2.PNG

1 Reply
Highlighted

@Ashraf34 

It looks like a job for Power Query, you may dig in this direction.