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!
