apologies as I'm sure this is very basic but I am very new to alteryx so looking for a little help or something to get me started. i am sure this is super easy but again i could use a little guidance.
Thank you all!
currently i have excel data as follows:
| Name 2019 | USA 2019 | Name 2018 | USA 2018 | Name 2017 | USA 2017 |
| John | 5 | Alex | 5 | Marisa | 7 |
| David | 2 | Reagan | 98 | Reeves | 24 |
| Angela | 100 | Marisa | 8 | Logan | 19 |
| Reggie | 50 | John | 99 | David | 852 |
i want this data to look like:
| Name | USA 2019 | USA 2018 | USA 2017 |
| John | 5 | 99 | - |
| David | 2 | - | 852 |
| Angela | 100 | - | - |
| Reggie | 50 | - | - |
| Alex | - | 5 | - |
| Reagan | - | 98 | - |
| Marisa | - | 8 | 7 |
| Reeves | - | - | 24 |
| Logan | - | - | 19 |
