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 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Nov 5, 2012 at 10:57 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Nov 5, 2012 at 10:57 AM
Related:
- Matching columns in one spreadsheet
- Display two columns in data validation list but return only one - Guide
- Google spreadsheet right to left - Guide
- Functions of spreadsheet - Guide
- We couldn't find an account matching the login info you entered, but found an account that closely matches based on your login history. - Facebook Forum
- Excel intersection of two columns - Excel Forum
2 responses
pommy pete
Posts
1
Registration date
Sunday October 28, 2012
Status
Member
Last seen
October 28, 2012
Oct 28, 2012 at 10:09 PM
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
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
December 27, 2022
552
Nov 5, 2012 at 10:57 AM
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
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
