Excel, modify duplicate line data

Asked

Viewed 42 times

0

Good afternoon, you guys.

I am very bad of Excel and appeared a demand to me that to do manually will give a monstrous workmanship, so I come to you.

This is the scenario.

    A     | B   | C  |
1-  Tiago |     |    |
2-  Tiago | ok  |    |

I have to pass this ok from cell B2 to cell C1, and after that delete line two, since this in my table is a duplicate data.

I used this example, but in the table I am at hand I have more than 10 thousand lines, someone could help me ?

  • Would the duplicated data be only in column A or more columns? There may be more than two rows with the same record?

  • In more columns, duplicated data is name, tel and DDD, I have only two rows with the same record.

No answers

Browser other questions tagged

You are not signed in. Login or sign up in order to post.