How to achieve this output

[Ralphlahens]

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
	Category	Target 1	Target 2	Target 3
	A	1	2	3
	B	4	5	6
	C	7	8	9
	D	10	11	12
	E	13	14	15
	F	16	17	18

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 Name	Branch Name	Year	Category	Target #	Amount
New York	Green	2021	A	1	1
New York	Green	2021	A	2	2
New York	Green	2021	A	3	3
New York	Green	2021	B	1	4
New York	Green	2021	B	2	5
New York	Green	2021	B	3	6
New York	Green	2021	C	1	7
New York	Green	2021	C	2	8
New York	Green	2021	C	3	9

[Luke_C]

Hi @Ralphlahens 

Here's one way. Isolate the data and the header using sample tools. The header info needs to be cross-tabbed and appended to the dataset. Then the dataset just needs to be transposed to get the target #s how you need them.

[Ralphlahens]

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

[grazitti_sapna]

@Ralphlahens , here is another way of doing it.

[Ralphlahens]

Thank you so much!