Macro to output different set of data into different sheet in the same workbook

[wongkenny240]

Item	Year
X	2018
Y	2018
Z	2019
A	2019
B	2020

If I have the above set of data, is it possible in Alteryx to output these data into 3 different sheets for each year (the first two into a sheet named "Year 2018", the next two into a sheet named "Year 2019" etc) by a macro?

Thanks 

Kenny

[Blake · Accepted solution]

Hey @wongkenny240 

No need for a macro, you can group based on your data for your output. 

See the screenshot below and attached example. 

[Qiu]

@wongkenny240 
Since you mentioned that sheet name to be  like "Year 2019", so I added a formula tool to create such sheet name.