Previous Topic Next Topic

Matching columns in one spreadsheet

Closed
Angie71
Posts
1
Registration date
Sunday October 28, 2012
Status
Member
Last seen
October 28, 2012
 - Oct 28, 2012 at 08:11 PM
TrowaD
Posts
2884
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
June 21, 2022
 - Nov 5, 2012 at 10:57 AM
Hello,


I have a spreadsheet that has last names in column A and first names in column B. Somehow they no longer match. For instance -Mary Smith would have Smith in column A, row 839 but have Mary in column B of row 838. Some how my names are now one row off. Any suggestions as to how to correct this? Thanks

2 replies

Answer 1 / 2
pommy pete
Posts
1
Registration date
Sunday October 28, 2012
Status
Member
Last seen
October 28, 2012
Oct 28, 2012 at 10:09 PM
Sorry got called away select both colums and sort & filter, I don't know if that will sort your info out you mayhave to start again. Hope I am right Pommy Pete
0
Answer 2 / 2
TrowaD
Posts
2884
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
June 21, 2022
 512
Nov 5, 2012 at 10:57 AM
Hi Angie,

Just copy a single cell. Right-click on a cell which you would like to move and select "Insert copied cells". Excel will then ask you to move cells up or down. Choose wisely and your columns should line up again.

Best regards,
Trowa
0