Take the 2-minute tour ×

I need to change the format of an excel spreadhseet from six columns to one, where each event is stacked on top of the other in date order. At present I have:

Event name, date, city, country, price, website

And I need

Event name






for all 101 events on the list. Can anyone help!?



share|improve this question
I suspect the answer by Roobert-P is not going to meet your need. If not you will need to provide more information about the data, and possibly rethink your question. How would you keep your data grouped and sort it by date, without manaually making everychange? –  James Jenkins Oct 22 '13 at 11:55

1 Answer 1

Please find below Screen shot, Hope this Helps.

Before Copying Sort Date Column.

enter image description here

share|improve this answer

Your Answer


