The_excell_initiate
New member
- Joined
- Nov 24, 2015
- Messages
- 9
- Reaction score
- 0
- Points
- 0
- Excel Version(s)
- 2013, 2016
Hey Guys,
Was hoping someone could help with this. I have a set of data somewhat similar to this:
What I am trying to achieve is a pivot table that shows the following
So what I need is a way for excel to identify all the months it was active , for example item 4 was active in January, February and March. So I would need it to report under all three months.
I know I can do this by splitting them onto individual lines and adding another column, but i do expect excel is smarter than this.
Hope someone can help.
p.s. running version 2013
Was hoping someone could help with this. I have a set of data somewhat similar to this:
Open Date | Close date | Item | Owner |
01/01/2017 | 05/02/2017 | Item 1 | Peter |
05/02/2017 | 07/02/2017 | Item 2 | John |
05/02/2017 | 15/02/2017 | Item 3 | Peter |
24/01/2017 | 15/03/2017 | Item 4 | John |
What I am trying to achieve is a pivot table that shows the following
John | Peter | |
January | Count of items | Count of items |
February | Count of items | Count of items |
March | Count of items | Count of items |
So what I need is a way for excel to identify all the months it was active , for example item 4 was active in January, February and March. So I would need it to report under all three months.
I know I can do this by splitting them onto individual lines and adding another column, but i do expect excel is smarter than this.
Hope someone can help.
p.s. running version 2013