Hello,
I'm trying to manipulate the output from a program in order to make it usable in a pivot table. Currently the output will display both sub-headings and data in the same column, and I need a formula that can search up the column to find the sub-heading for that data then output the data to a new column to the right of the data.
the current output looks like this:
PROJECT ProjectA
RESOURCE john Smith
RESOURCE Peter Jones
RESOURCE Rupert Brown
PROJECT ProjectB
RESOURCE Ralph Simpson
What I am hoping for is a formula that can lookup Column A to find the next instance of "PROJECT", then place the Value in Column B for that row beside the resource name, as below:
PROJECT ProjectA
RESOURCE john Smith ProjectA
RESOURCE Peter Jones ProjectA
RESOURCE Rupert Brown ProjectA
PROJECT ProjectB
RESOURCE Ralph Simpson ProjectB
Unfortunately there is no consistency in the output from a month to month basis, so I can't use fixed cells for the sub-heading.
Any assistance that anyone can provide would be greatly appreciated. I've been searching google, but without luck so far.
Thanks
Glen
Bookmarks