Delete Duplicate Lines and Sort Lines From a Text

How to Remove duplicate rows in Excel

It’s a little troublesome, but you can do it with Excel.

Remove duplicate rows:

1. Select the range of target cells.
2. Click Data > Remove Duplicates.
3. Click OK.

Sort rows:

1. Select the range of target cells.
2. Click Home > Sort & Filter.
3. Click Sort A to Z or Sort Z to A.