Parse Excel cells based on a stacked value
Posted on 2014-11-14
I have received a spreadsheet (SS) from a client that has cells with stacked values in it.
Below is an example of the column name and 3 stacked values:
However, the client has only associated only ONE Tract_ID value associated with the 3 stacked values.
In the case above we have a 1:Many relationship (ONE Tract_ID to MANY Parcel_IDs).
My goal is to parse this Parcel_ID field so that each row contains ONE Parcel_ID and ONE Tract_ID, or a 1:1 relationship.
For a better idea of what I'm talking about please open the attached SS "Parsing.xlsx". It is a model of the actual SS. The SS has many more rows (~70) and columns (~15).
In it there are two tabs; BEFORE Parsing and AFTER Parsing.
The AFTER Parsing tab is what I'm trying to achieve.
Due to the urgency of this matter, I'm going to push the points total to 500.
TIA for your replies!