Running into a snag on how to solve this problem. Relatively new to designer. Here we go.
How would I get this
| Zip | Service Line |
| 45067 | Heart |
| 45212 | Heart |
| 45067 | Comp Medicine |
| 45026 | MSK |
| 45212 | Comp Medicine |
| 45067 | Heart |
| 45078 | MSK |
| 45026 | MSK |
To become this?
| Zip | Comp Medicine | Heart | MSK |
| 45067 | 1 | 2 | |
| 45212 | 1 | 1 | |
| 45026 | | | 2 |
| 45078 | | | 1 |
I have been playing with the multi row formula tool and the of the transform tools.
Any help is much appreciated! Thanks!
