Want to get involved? We're always looking for ideas and content for Weekly Challenges.
SUBMIT YOUR IDEABrute force and totally not scalable. but I got it done. It lays out the [Null] fields in the Merchant2 position -- it makes more sense to me that a shopper would go from a store to no other store, then they would go from no store to a store.
Looking back I probably could have used an iterative macro to conduct this, but I still reached the desired outcome.
Perhaps if the solution required to be scaled, then an iterative macro would best suit this workflow.
lots of multirow and filters.
Always a "D'oh" moment for me when I look at other people's solutions and they come up with amazingly simple solutions!