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!!!!
Bookmarks