Solved! Go to Solution.
Hi Brian,
I'm not 100% on whether I understand this correctly and I apologise if I'm over-simplifying but it sounds like you have the following structure:
As Such:
And what you want is:
As Such:
This can be obtained through the Crosstab tool with Name set as the Grouping field, "Phone_Type" as the Header Field and "Phone_Number" as the Data Field. You will need to tick a Methodology but for this instance either Sum or Average will be fine as long as you check your data.
If there is a possibility of having multiple entries for the same Person/Type combination (i.e. 2 Mobile numbers for one person, represented by 2 separate lines) then first perform a sort based on "Identifier", "Phone_Type", then a Multi-Row Formula Tool with the following updating Phone_Type (Note: This will only work for 2 instances of the same combination, it would need to be edited further, probably dynamically, if there was for instance 3 Mobile Numbers for one person):
Does Alteryx allow text values in the cells in this pivot or does it have to be numbers like Excel?