Thread: [Solved] How do I do this?
View Single Post
 
Old 05-03-2016, 09:00 AM
gebobs gebobs is offline Windows 7 64bit Office 2010 64bit
Expert
 
Join Date: Mar 2014
Location: Atlanta
Posts: 837
gebobs has a spectacular aura aboutgebobs has a spectacular aura about
Default

I can think of a way but it's not a formula.

* Data:Sort (by Date then Month)
* Data:Remove duplicates
* For each month, select the dates and do Paste Special:Transpose
* Delete the extra rows of months.
Reply With Quote