Matching columns in one spreadsheet
Closed
Angie71
TrowaD
- Posts
- 1
- Registration date
- Sunday October 28, 2012
- Status
- Member
- Last seen
- October 28, 2012
TrowaD
- Posts
- 2884
- Registration date
- Sunday September 12, 2010
- Status
- Moderator
- Last seen
- June 21, 2022
Related:
- Matching columns in one spreadsheet
- Matching columns ✓ - Forum - Excel
- If column a matches column b return column c ✓ - Forum - Excel
- Excel partial match two columns - Guide
- Excel match two columns and output third ✓ - Forum - Excel
- VBA search column for matching string ✓ - Forum - Excel
2 replies
pommy pete
Oct 28, 2012 at 10:09 PM
- 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
TrowaD
Nov 5, 2012 at 10:57 AM
- Posts
- 2884
- Registration date
- Sunday September 12, 2010
- Status
- Moderator
- Last seen
- June 21, 2022
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