Hi

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
Column2: Date1
Column2: Date2
Column3: Date3

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

Rodders

Highlight all the cells.
Copy them.
Paste Special in a new Worksheet.
Check the Transpose option.

Another option would be to TRANSPOSE(array). Look up Transpose in Help.

Does each item definitely have three associated dates, or can some only have one or two dates?
Also, do you want to do this once, manually, or do you want a VBA solution?