Hi @csh8428,
Alteryx will not allow you to have multiple fields with the same name, as field names are actually used as field identifiers (i.e. you can't have 2 'Email' fields, but you can have 'Email_1' and 'Email_2'.
The attached solution is not the most elegant one, but it gives you what you want and potentially explains how to use the Cross Tab tool. By the way have a look at the built in examples to learn how to use it (click on the Cross Tab tool from the top palette -> Open Example).
Macros would probably avoid the repetition of the cross tab and rename tools, but can I ask you why you want the data in that specific format?
I'm asking because potentially we could approach the problem from a different angle if I know more about your use case.
Giuseppe
