week to month conversion

[pokhan27]

Hi experts

i have a week number in first row and year in second how do i convert  this, can i concatenate row like 2019-12 as single value

NAME	12	13	14	15	16	17	18	19	20	21	22	23	24
NAME	2019	2019	2019	2019	2019	2019	2019	2019	2019	2019	2019	2019	2019

[RishiK]

@pokhan27 you can play around with the Transpose and Crosstab to achieve this as per the workflow attached:

Here is some more info on both tools:

https://help.alteryx.com/2018.3/Transpose.htm?tocpath=Tools%7CTool%20Categories%7CTransform%7C_____6....

https://help.alteryx.com/20212/designer/cross-tab-tool#:~:text=The%20Cross%20Tab%20tool%20is,through....