Microsoft Office Forums - View Single Post - [Solved] How do I do this?

Thread: [Solved] How do I do this?

View Single Post

Old

05-03-2016, 09:00 AM

gebobs

gebobs is offline

gebobs uses Windows 7 64bit

Windows 7 64bit gebobs uses Office 2010 64bit

gebobs uses Office 2010 64bit

Office 2010 64bit

Expert

Join Date: Mar 2014

Location: Atlanta

Posts: 837

gebobs has a spectacular aura about

gebobs 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