You are reading a single comment by @Chalfie and its replies. Click here to read the full conversation.
  • That feeling when you get emailed 40 workbooks of data from the same database to analyse, because someone else somewhere asked for things to be broken down across 10 locations and 4 financial years at the wrong point in the process.

    Is there a quick option to combine these into one worksheet? I'm assuming I should save them all into one directory then cast a spell to import & combine everything or something?

  • If they’re all the same format and the data is on the same sheet:
    Open ChatGPT
    I want to import data from this single location into one book using power query

  • Thanks, I'll give it a go this way, at least they'll all be in the same folder at worst case.

About

Avatar for Chalfie @Chalfie started