Consolidate data

[knaabis]

Row has, for example these digits in different cells:
1 2 3 1 4 5 2
I need to remove duplicates and consolidate these digits like this:
1 2 3 4 5

 

[tyija1995]

Re: How to connsolidate data

Hey,

I'd use the Remove Duplicates tool that is in the Data ribbon tab, and then in a separate cell use =TEXTJOIN(" ",TRUE,*Range of the unique numbers*)

EDIT: If you need to preserve the column then copy it across to another column and then remove duplicates from the copied range and reference that in TEXTJOIN.