I receive a rather large data dump that lists product, availability start date and availability end date in separate columns (10K + rows). Some availability dates may be repeated, or be non-contiguous. Is there any way for VBA to help me quickly identify the true periods of availability? I have also included a screen capture of the example data dump and example target result here: https://imgur.com/a/YJs8w
DUMP
Product A Available: 10/1/17 - 1/31/18, 10/1/17 - 1/31/18, 11/1/17 -12/31/17, 4/1/18 -6/30/18
Product B Available: 11/1/17 - 2/28/18, 10/1/17 - 12/31/17, 5/1/18 - 6/30/18, 6/1/18 - 8/31/18
Product C Available: 10/1/17 - 12/31/18, 6/1/18 -7/31/18, 1/1/19 - 3/31/19
TARGET RESULT
Product A Available: 10/1/17 - 1/31/18, 4/1/18 -6/30/18
Product B Available: 10/1/17 - 2/28/18, 5/1/18 - 8/31/18
Product C Available: 10/1/17 -3/31/19
Any help is greatly appreciated.
Please let me know if there is any way I can improve my question.
Thanks!