Please help - Month end wise status in column wise

[Ravinder1]

Dear Month end wise status in column wise output - only 13th Month

Table	Table	Table	Table	Table		Output	Output	Output	Output	Output	Output
ID	Flag	Month	Month end	Status		id	Flag	Month end May22	Month end Jun22	Month end July22	Month end Aug22
1234	13th Month	Jun-20	May-22	Paid		1234	13th Month	Paid	Paid	Paid	Paid
1235	13th Month	Aug-20	May-22	Not Paid		1235	13th Month	Not Paid	Paid	Paid	Paid
1239	13th Month	Sep-20	May-22	Not Paid		1239	13th Month	Not Paid	Not Paid	Not Paid	Not Paid
1240	13th Month	Dec-20	May-22	Paid		1240	13th Month	Paid	Paid	Paid	Paid
1236	13th Month	Jan-21	May-22	Not Paid		1236	13th Month	Not Paid	Not Paid	Paid	Paid
1237	13th Month	Nov-20	May-22	Not Paid		1237	13th Month	Not Paid	Not Paid	Not Paid	Not Paid
1238	25th Month	Jun-19	May-22	Not Paid		1238	25th Month	Not Paid	Not Paid	Not Paid	Paid
1234	13th Month	Jun-20	Jun-22	Paid
1235	13th Month	Aug-20	Jun-22	Paid
1240	13th Month	Dec-20	Jun-22	Paid
1236	13th Month	Jan-21	Jun-22	Not Paid
1237	13th Month	Nov-20	Jun-22	Not Paid
1238	25th Month	Jun-19	Jun-22	Not Paid
1234	13th Month	Jun-20	Jul-22	Paid
1235	13th Month	Aug-20	Jul-22	Paid
1240	13th Month	Dec-20	Jul-22	Paid
1236	13th Month	Jan-21	Jul-22	Paid
1237	13th Month	Nov-20	Jul-22	Not Paid
1238	25th Month	Jun-19	Jul-22	Not Paid
1234	13th Month	Jun-20	Aug-22	Paid
1235	13th Month	Aug-20	Aug-22	Paid
1236	13th Month	Dec-20	Aug-22	Paid
1236	13th Month	Jan-21	Aug-22	Paid
1237	13th Month	Nov-20	Aug-22	Not Paid
1238	25th Month	Jun-19	Aug-22	Paid

[v-yangliu-msft]

Hi  @Ravinder1 ,

It's not clear about your specific logic, but you can try it according to the following way to achieve consistent results

Here are the steps you can follow：

1. Select [Month end] – Transform – Pivot Column – Values Column:Status – Don’t Aggreate.

2. Remove [Month].

3. Result:

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly