Still confused... but I have had a bash...
GREEN cells below. No formulae, but data are separated.
Orange cells above, formulae in place.
The remaining cells are NOT touched.
Is this what you wanted? If so, I can explain and tell you waht YOU need to do to finish the job. Also, I would populate the green cells from drop-down boxes, instead of free text to prevent mistaken entries.
If not, then you will need to show what you want MUCH more clearly....
Bookmarks