Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
My input Data like below
Month | Product |
5/1/2017 | A |
4/25/2017 | B |
4/10/2017 | X |
4/7/2017 | B |
3/23/2017 | B |
3/22/2017 | R |
3/22/2017 | B |
3/8/2017 | C |
2/28/2017 | C |
2/14/2017 | X |
2/8/2017 | C |
2/8/2017 | S |
2/6/2017 | C |
1/27/2017 | C |
1/25/2017 | D |
1/18/2017 | D |
1/17/2017 | D |
1/17/2017 | I |
1/17/2017 | D |
1/17/2017 | D |
1/12/2017 | J |
1/12/2017 | E |
1/11/2017 | M |
1/10/2017 | E |
expected out put should like below , trying with monthsrat ? but some records are missing
Month | Product |
May-2017 | A |
APR-2017 | B |
X | |
B | |
MAR-2017 | B |
R | |
B | |
C | |
FEB-2017 | C |
X | |
C | |
S | |
C | |
Jan -2017 | C |
D | |
D | |
D | |
I | |
D | |
D | |
J | |
E | |
M | |
E |
Thanks,
You don't want the date to repeat? On the front end? In like a pivot table or are you looking to do something like this in the script? Can you share more details around what records are missing?
Like this?
PFA....
Maybe:
Date(Date#('5/1/2017', 'MM/DD/YYYY'), 'MMM-YYYY')