Bar plot with different order and values

[mikhanx1]

Hi All,
How can I plot the following graph from input shown in figure?

I also want to keep the order of occurrence of each soil in BHs. For example Soil C occurs at the bottom of BH01 and at the top of BH02. I want to keep this order. 

. Thanks