Forum Discussion

  • Lorenzo's avatar
    Lorenzo
    Silver Contributor
    Dec 18, 2023

    Hi nattiej101 

     

    I see you raised 'a bit of a problem...' twice (it's useless) already


    In principal reformatting data is something that can be done with Get & Tranform (aka Power Query) and maybe with VBA or Office Script

     

    I looked your 2 files to get a sense of the feasibility with Power Query. Each file has > 1 sheet and you don't say which one(s) contains the data to 'capture'. If it's sheet 'Assy WA Data' this sounds doable*, for the others this looks (almost) mission impossible IMHO

     

    * For sheet 'Assy WA Data' I can take a look at doing it if you indicate which columns should be captured (in each file) + for April 2021 what should be the header for the 1st column:

     


    NB: Assuming I can do it for the 2 files you shared, if your other ones are not formatted the same you will have to adapt to queries...

Resources