How to achieve this output

Question

Hello everyone! I am very new to Alteryx and am looking for some help to transform my data set.

I am working with a dataset that looks like this

City Name New York   Branch Name Green   Year 2021         CategoryTarget 1 Target 2 Target 3  A123 B456 C789 D101112 E131415 F161718

I want to take the information and create a new table where for each number I pull the Column Name, the category as well as the misc. information on the top left so that the resulting table looks sort of like this.

City NameBranch NameYearCategoryTarget #AmountNew YorkGreen2021A11New YorkGreen2021A22New YorkGreen2021A33New YorkGreen2021B14New YorkGreen2021B25New YorkGreen2021B36New YorkGreen2021C17New YorkGreen2021C28New YorkGreen2021C39

Ralphlahens · Answer

Thank you so much!

grazitti_sapna · Answer

@Ralphlahens , here is another way of doing it.

New Workflow1.yxmd

Ralphlahens · Answer

Thank you so much, I'll try it out right now!