Sorting or Arranging Columns with incorrect Row data

excelboxnovice

New Member
Joined
Mar 6, 2016
Messages
8
I am very new to Excel so please excuse the limited knowledge of asking this question within this community.


In Excel spreadsheet I have Twenty plus Columns, each with Headers, Example, Name, Email, Category, Phone, Address. Within each row down the column includes the marker and following details format


A. Row 1A: Email: Row 2A mailto: email: bob@domain.com


B. Row 1B Address: Row 2B address: 1234 Find Street.


C. Row 1C Phone: Row 2C phone: 12345


Etc


Now the problem, some of the rows are mixed up. Some of the data for Column C is showing within Column A & B. Some of the data for column A is showing up in column B & C.


What would be the best method to fix this issue, I need any data related to email in the correct column A even its on other columns.


I have tried multiple attempts but when dealing with twenty plus columns, I can't figure out the best method to fix this problem.


Another bit of info. The data within the rows, 1, 2, 3, are need to stay within their row because they are all associated with each other.


Example, Row 1. Email, Phone, Address, etc.


I look forward to your reply and thank you in advance for your feedback.


Please try to keep the answers very detailed (step by step) because of my limited excel knowledge.
 

Excel Facts

Fastest way to copy a worksheet?
Hold down the Ctrl key while dragging tab for Sheet1 to the right. Excel will make a copy of the worksheet.

excelboxnovice

New Member
Joined
Mar 6, 2016
Messages
8
Hello,

Here's the screenshot, https://gyazo.com/ff8cb32b8727e799c6315b7189fc0f34

I would like to include the actual sheet for review but don't see a attachment button available. Basically, I need to move the rows under the correct column without changing their order..

1.
2.
3.
etc.

I would really appreciate any feedback as how to fix this issue.
 
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

Forum statistics

Threads
1,163,936
Messages
5,834,477
Members
430,289
Latest member
Tphil413

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top