I handle large amounts of data on chemical substances. There is unique information for each chemical, but there is repetitive information that is required to be prepared and processed.

I do not have much knowledge of coding, automated functions in Excel, or even AI tools for these matters. I only know one Macro feature in Excel but that is all I know. The pace and amount of data is just increasing over the months. So, I wonder where to start leveraging existing tools that I can use for such tasks.