Segregate data Monthly basis

[AS]

Hi Experts,

Here is the table I have to segregate data on monthly basis what could be the best way to do it without mentioning the month 

Department: Name	Type	Month
000	Bill Payment	Oct 2021
000	Payment	Dec 2021
000	Payment	Jan 2021
000	Payment	Oct 2021
000	Journal	Jan 2021
000	Payment	Jan 2021

[atcodedog05]

Hi @AS 

Any thought on what your expected output should look like 😅

[saisaranv]

Any sample data as output? which columns are expecting in Output?

[AS]

Hi ,

Please found attached tables-

Department: Name	Amount	Type	Month
000	3400	Bill Payment	Oct 2021
000	2320	Payment	Dec 2021
000	34320	Payment	Jan 2021
000	223	Payment	Oct 2021
000	454	Journal	Jan 2021
000	4454	Journal	Dec 2021

The Expected Output-

Department: Name	Type	Jan	Oct	Dec
000	Bill Payment		3400
000	Payment	34320	223	2320
000	Journal	454		4454

[atcodedog05 · Accepted solution]

Hi @AS 

Here is how you can do it.

Workflow:

Hope this helps : )

[AS]

thank you so much @atcodedog05 that is really helpful. 

[atcodedog05]

Happy to help : ) @AS 

Cheers and have a nice day!