Hi all
I have a spreadsheet that has information in it where I only want to see information from rows that have the dates included.
I was wondering if a pivot could be done with this information to show the title names down the left hand side then the columns K, L & M which has dates in it.
This would then allow the user to easily see what the title is and the dates inputted for Idea, Application, Transition (K,L,M) which then filters out the blanks as they haven't had dates assigned.
I was then thinking the final column in the pivot would simple show the BRM assigned information.
Is this possible or is there a better way do you think?
Would this be better as maybe a formula, your expect advice is welcome - please see sheet attached.
Regards
Matt
Bookmarks