Extract a particular phone number after using a group by

[Anonymous]

I have some source data that for each unique person has a new row for each of the phone numbers on record. A simple example is:

 I can use 'group by' and then concatenate the phone numbers in a list and extract them into a custom column. What I need to do is get the one mobile number into its own column (In Australia the mobile numbers start with a '4' and are 9 digits long.

Ideally I would like to end up with:

Any suggestions would be appreciated!

[Anonymous]

Thanks Rocco!

[Anonymous · Accepted solution]

like this?