I have been trying to find a way to do this for a few weeks and have come up empty handed so any help will be very gratefully recieved.
I have a ssheet with rows with 3 date columns eg.
Column1: Item Name
with multiple row...
I would like to be able to have a new sheet generated from this data which iI can sort:
Column1: Dates (from Date1, Date2, Date3)
Column2: Item Name
To put this in context, the items are Events, the dates are dates I wish to publicise these events using social media, so 28 days before, 14 days before, 7 days before.
I would like the dates all in one column with the corresponding item name so I know what social media activity has to happen on what day.
Many thanks in adavance