Extract Information from a column to make a separate table

[kaleonard08]

I received a spreadsheet that has a column filled with information that needs to be separated out. Each cell in the column has multiple sources and values that I want to extract. However, I want to keep the same # of rows as they correspond with a person.
For example: Column A has a name, Column B has a Title, Column C has a Status, and Column D has the # per source. However, each cell has multiple sources.

Column D, Row 1 has "Website: 25Board: 97"
Row 2 has "Referral: 1"
Row 3 has "Employee Referral: 16Website: 19Board: 11"

Is there any way to extract this information and turn it into columns so I have the columns as website, board, referral and have the rows just have the number in which it is?

I hope I explained this well enough. Any help or suggestions would be greatly appreciated!

Thanks!!!!

[Kaper]

Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

[kaleonard08]

I have attached a sample workbook with a BEFORE and AFTER tab. Thank you so much for your help!

[AlKey]

Enter formula in B2, copy across and down

Please Login or Register  to view this content.

Please see attached file.

[kaleonard08]

Thank you!!

[kaleonard08]

Hi,

I was wondering if you would be able to explain the formula above. I want to understand how and why you chose this formula and kind of how it works. I am trying to figure it out myself right now and I am just not sure where to start.

Thank you for your time!