Rearranging Data Help...
 

I have a date in cell E41 (Saturday, April 9) with team names underneath it
(cells E42-E48). I also have team names in cells F42-F48. Then in cell E50
I have the date Sunday, April 10 with team names under it also (cells
E51-E57). There are also team names in cells F51-F57. I would like to have
the date Saturday, April 9 entered in cell A44-A50 and have the teams from
cells E42-E48 automatically entered into cells B44-B50 and the teams from
cells F42-F48 automatically entered into cells C44-C50. Then have this
procedure repeat for each date.

If you don't understand I can email you a copy of my sheet and you will
understand. Thank you.