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

Hey @wongkenny240 

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

See the screenshot below and attached example. 

wongkenny.yxmd