I have an excel sheet with multiple client data and specific values. Please find the screenshot below
Based on client name(For ex, for the client AMSI in column A, I want to get the ADLD value which is DIFF value (D column)
similarly, for the client Cantik, I want to get both column A values that are under Cantik client and respective DIFF values(Column D) and so on…
I am unable to get the respective client values because the client names are in vertical order. Is there any way to filter to get client wise data?
Thanks in advance.