Separating / re-organizing a data set by day of the week

[jmcfa001]

I have a data set that gives a specific value for each day of the week for one year.
I have 3 columns, the actual date, the day of the week, and the value. Something like |12/5/12 |Wednesday|0.0236|
Is there a way to separate my data set so that all of the Monday data points are together, all of the Tuesday points are together, Wednesday, etc.?
I'm hoping to run an ANOVA to look for differences between days of the week.

Thanks in advance

[FDibbins]

Hi and welcome ot the forum

=WEEKDAY() will give you the day of the week (1-7), you can then sort on that?

[jmcfa001]

That might have been helpful!
I figured it out, but it wasn't a very graceful solution ha

I merged the day and data point with "=B1&A1" , giving me "Wednesday0.12412"
I then used the sort "A->Z" function.
I then selected all the data for one day of the week and used "Text to columns" and set a manual delineation to separate the day and number. Then repeated for each day of the week.
Then ran ANOVA


There must be an easier way