Creating a sequence table with different column counts
I’m hoping to create a TOCOL in excel of an array of values based on variable criteria.
Eg. When it meets one criteria, I wish for it to be able to return an array of values associated with that criteria (eg stores in that region), and when it meets another criteria return values associated to that criteria.