Hello - I am trying to convert an excel file into a database file and the data looks like in the left image below. I have set up a workflow to select records for under each of the location (Camp Springs, Largo, etc) and then manipulate the data to make it look the way I want it to. The way I am doing it right now is per the image below: Is there a way for me to avoid repeating the select records process and use a tool (sort of like a macro) that can select records at specified intervals? Thanks a lot in advance.
Best,
Jo
Solved! Go to Solution.
Worked like a charm!!! Thank you so very much for your prompt response and help :)