Consolidated/filtered list issue
 

I need to filter a list from one place on the worksheet to another
place.
I cannot use the advance filter method as there is other supporting
information that I dont need to altered in anyway. Advance filter
seems to hide these rows which alters the other data on the sheet.

I've spend days creating a code to copy the list, create another
temporary sheet, paste the data, delete duplicates, copy that
(filtered) data, then paste it on the original sheet, then delete the
temporary sheet.

However, this has got to be the longest, most complicated and
troublesome route ever!

Any suggestions that could help?
Main goal is to create a consolidated list (filtered / with no
duplicates) in another row while leaving the original list as is.

Data to copy and filter out the dupes :
L13:L250

Desired location for consolidated list (filtered / with no
duplicates).
Q13:Q250