Best plot option for mix of categorial/numerical data

Great descripion of the data layout though some sample data would be handy. See FAQ: How to do a minimal reproducible example ( reprex ) for beginners for some suggestiins on how to provide some. Perhaps just a sample of the data set in dput() format is all that is needed. It saves us mocking up a data set and it better to work with real data.

The real issue here is what substantive question are you asking, in general terms? What the question is determines the choice of display. It sounds like you want to display 5 pieces of information per borehole at a single point on a graph, one numeric and 4 categorical.

I think it can be done in theory but I am not sure how easily. Would it be feasible to display the data in multiple panel?