To remove duplicate values, use the Remove Duplicates command in the Data Tools group on the Datatab.



Here's how to sort unsorted dates:
Drag down the column to select the dates you want to sort.

Click Home tab > arrow under Sort & Filter, and then click Sort Oldest to Newest, or Sort Newest to Oldest.


To concatenate 2 strings with dot.

=concat(text1,".",text2);

'GPCOMP1.GPCOMP1.GPCUST', = to get this

=concat(" ' " , text1 , "." , text2," ' " ," ,")