Hi
How to convert EXCEL table?
This is the current form
| Name | Type | item |
|---|---|---|
| SAAB | A | XXX |
| Speedway | A | YYY |
| Netflix | B | ZZZ |
| SAAB | A | ZZZ |
Output…
| XXX | YYY | ZZZ | |||||
|---|---|---|---|---|---|---|---|
| A | B | A | B | ||||
| SAAB | 1 | 1 | |||||
| Speedway | 1 | ||||||
| Netflix | 1 |
How can I go about doing this please?
Thanks in advance!
Try using pivot table and add type and name as columns ,name as row and value as sum of type
Cheers
1 Like
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.