Changing from data from column to row in Excel is important for many reasons, such as changing the axis of a graph, constructing a different table or detecting duplicates. In this article, I would like to share a simple way to change or transpose the data in a row to a column and then detect duplicates in the data.
Copying Data From a Row
The first thing first, click on the first element in the row.
Then, click on the last element of the row while holding the SHIFT key. Your data will be highlighted from the first element until the last element of the row.
Press Ctrl+C to copy.
Paste the Selected Row into Column
Next, select an empty cell, as in example below
Select paste, then select transpose You will get a transposed column.
Detecting Duplicates in the Data
Now, delete the row that contains the original data. You will have only the transposed column. Then, click on the column header to highlight the whole column. Select Sort and Filer, then Sort Smallest to Largest
That`s all for today. Excel is easy. Now, you are able to see the duplicates easily after it was sorted. That’s all for this article. Excel is easy.