Hello,
I have an excel file like below and I would like to enter data in Jan-Mar fields using Alteryx .
| Customer Name | Category | Jan | Feb | Mar |
| Instagram | Service1 | | | |
| Google | Service1 | | | |
| Facebook | Service1 | | | |
| Instagram | Service2 | | | |
| Google | Service2 | | | |
| Facebook | Service2 | | | |
| Instagram | Service3 | | | |
| Google | Service3 | | | |
| Facebook | Service3 | | | |
| Instagram | Service4 | | | |
| Google | Service4 | | | |
| Facebook | Service4 | | | |
However my output from Alteryx workflow is somewhat like below:
| Customer Name | Category | Jan | Feb | Mar |
| Google | Service1 | 173 | 184 | 188 |
| Google | Service2 | 195 | 140 | 132 |
| Google | Service3 | 185 | 140 | 198 |
| Google | Service4 | 123 | 121 | 191 |
| Facebook | Service1 | 126 | 115 | 106 |
| Facebook | Service2 | 113 | 114 | 183 |
| Facebook | Service3 | 181 | 200 | 108 |
| Facebook | Service4 | 125 | 192 | 178 |
| Instagram | Service1 | 106 | 156 | 116 |
| Instagram | Service2 | 184 | 163 | 181 |
| Instagram | Service3 | 142 | 102 | 114 |
| Instagram | Service4 | 142 | 152 | 163 |
The customer name and Category fields are not in same order always, is there any way I can output the values by matching the customer name and category fields?
