Aug 30 2022 02:16 PM
Aug 30 2022 09:22 PM
@johnt9000 Looks like you need to turn to Power Query. Are you familiar with that? If you are no, it will take some time to get to know the tool.
A good point to start learning would be here:
If you are familiar with, you can set it up to connect to all files in a folder and define the steps that transform the data once, and PQ will apply them to all the files in the same folder. How exactly? That depends on the structure and consistency of your csv files. In your example, for instance, it is not very consistent and it seems to be missing information for the 9:50 transaction. Or, is that just due the fact that you created the example manually.
Best if you could share a realistic (though anonymised) csv file with say 30 rows of information and an xlsx file containing the expected end resultful those 30 rows. You can share it via OneDrive or something similar.
Sep 02 2022 02:39 PM