Hello! I need help with the following. In my input data, I have column labeled "Segment" and then A... B.... C... etc. I have to manipulate the data within each segment, so segment A, Segment B, Segment C.
In my attached file you see that, the data comes in, I filter on which segment I would like, it goes through its own little manipulation, and then comes together in a union. My issue is that when there are a million "segments" this takes me forever to build. Is there an easier way to have it automatically split into the segment, run through its query, and then come back together?
Then you would likely need the batch macro to do what you need.