How to remove blank in dependent data validation dropdown list

[m_vishal_c]

HI
as you can see in the attached image, i need unique value for dropdown list from column A and in the second row i need the corresponding value (ignore blank) in another data validation drop down list

i.e if i select 1061 Surveyor from one dropdown list then another dropdown list will show "Surveyor", "Dream Drafting", "Atk surveying","Building professional..","Land surveying services", ïntrax consulting.."
but if i select 1011 Temprory fence then "Coates" shows blank too

i am using below formula but it shows with blank
R10 is Trade(Dropdown list)
i am applying below formula on next row to get Discipline / Trade name (but i need without blank)
=OFFSET('Supplier List'!A1,MATCH(R10,'Supplier List'!A:A,0)-1,1,COUNTIF('Supplier List'!A:A,R10))

Please guide me. i have wasted too much time but could not find .

Heaps thanks in advance

 

[m_vishal_c]

I am very much impressed with your code. it works perfectly. Big thanks. I am going to close this query. if i need something in future, how can i contact you. thanks

 

[Akuini]

You're welcome, glad to help & thanks for the feedback.
You can mention me in any thread (@Akuini).