Date format ?

[Anonymous]

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,

[sunny_talwar]

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?

[prma7799]

Like this?

PFA....

[MindaugasBacius]

Maybe:

Date(Date#('5/1/2017', 'MM/DD/YYYY'), 'MMM-YYYY')