You need to post a true copy of what ever your starting with as you hinted a csv or a pdf. There is nom problem reading a csv and inserting all the borehole blocks at correct location, yes can look at other details so can insert different blocks when required, That is the sort of information you are not providing.
eg a csv file like this. I can see need to compare your look up table that you previously provided. Once this sort of information is posted then a complete solution can be provided. Not just questions.
Bore 1
X,Y
0.5,Green dirt
1.2,Black dirt
2.4,Blue dirt
Bore 2
X,Y
1.3,Green Dirt
2.2,Black dirt
Bore 3
and so on