Concatenate AND more... I think :-)

Hi All,

This forum has been helpful in the past so here we go again.

I am trying to extract SOME data from one cell and split it up based on a rule.

So I have this:

Team Members
Business Lead: Smith, John: john.smith@example.com
Finance Lead: Jones, Jack: jack.jones@example.com
Project Manager: Smith, John: john.smith@example.com

But I want this (Bold being heading, two columns of data):

Finance Lead Business Lead
Jack Jones John Smith

I have attached an example excel of what I am looking for and there are two sheets.

ANY HELP in the right direction would be fantastic.

Cheers

Kirban