Merge Duplicate rows

[qlikvw2019]

Hello,

I have data like below.

ITEM_ID , ITEM_NAME , CATEGORY are unique , but repeated in below data , due to different qty and region

ITEM_ID	ITEM NAME	CATEGORY	QTY	REGION
453	The Harry Potter	FICTION	12	NA
453	The Harry Potter	FICTION	45	EU
187	Nimona	COMIC	10	NA
987	Animal Farm	NONFICTION	40	NA
987	Animal Farm	NONFICTION	56	EU
987	Animal Farm	FICTION	43	NA
987	Animal Farm	FICTION	11	EU
360	Planet Hulk	FICTION	44	NA
568	Batman : Year one	FICTION	23	NA
568	Batman : Year one	NONFICTION	45	NA

I am looking for below output, should display one occurrence of each row per category and split the region into 2 columns

ITEM_ID	ITEM NAME	CATEGORY	#NA	#EU
453	The Harry Potter	FICTION	12	45
187	Nimona	COMIC	10
987	Animal Farm	NONFICTION	40	56
987	Animal Farm	FICTION	43	11
360	Planet Hulk	FICTION	44
568	Batman : Year one	FICTION	23
568	Batman : Year one	NONFICTION	45

Ex. Harry potter row needs to be repeated on one time (fiction only) and the #'s needs to be split into 2 columns.

Animal Farm has 2 occurrences instead of 4, (one per category) and the # should be split into 2 columns.

Thankyou for your help!

[fmvizcaino · Accepted solution]

Hi @qlikvw2019 ,

Attached is an example showing how to do it. For that type of manipulation, you can use a cross-tab tool.

Best,

Fernando Vizcaino

[qlikvw2019]

Thankyou for such a quick and accurate response!