unique sort function with filter

Hello all

I want to know how to use the filter formula to apply a unique sort..

In my data, column A has values which if I filter by, will return different values in column B.

I have to currently use the filter button to see all the values in column B, after selecting each unique value from column A

I want to a formula to return all the values in column A and maybe list the unique corresponding values next to in alphaetical order.

Amb- Continental Meats (selected from column A) column B values shows
Amb Cnti- Jerky
Amb Cnti- Other Ssg
Amb Cnti- Pepperami

maybe this can be transposed and go like this across cells? Amb Cnti- Jerky Amb Cnti- Other Ssg Amb Cnti- Pepperami

Any suggestions and help appreciated!

Formula:

Please Login or Register  to view this content.

Try this

=SORT(UNIQUE(A1:B65),1,1,FALSE)

thank you both, interesting solutions!