I have a workbook of date that I need to convert into a Pivot table/chart.
However, the headings that I need to sort on are all listed in column A. I
need to split this column into multiple columns for sorting purposes. Each
text stream in column A is starts with a "xxxxx :" ...where xxxx is
'resource', 'project', 'task', 'phase', 'activity'.
Any ideas would be greatly appreciated.
Here is a sample of the column....

Resource: Alex S
1 FTE


Project: Genesis
Task: Test Director Setup
Project: Rating
Task: Delivery
Project: Statistical Plan
Phase: Execution Phase
Project: Claims
Activity: Initiate / Plan / Execute / Closeout