Dynamically Aligning formulas to consume data in adjacent columns when using dynamic array function

[vjf326]

Is there a way to dynamically align formulas in a column adjacent to a column using the unique or filter function?

[#2]

@vjf326 

=SORT(UNIQUE(INDIRECT("C3:C"&COUNTA(C:C)+2)))

You can try this formula which dynamically returns the unique values from column C.