Thread
: [Solved]
How do I do this?
View Single Post
05-03-2016, 09:00 AM
gebobs
Windows 7 64bit
Office 2010 64bit
Expert
Join Date: Mar 2014
Location: Atlanta
Posts: 837
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.
gebobs
View Public Profile
Find all posts by gebobs