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.
 

Some videos you may like

Excel Facts

Copy a format multiple times
Select a formatted range. Double-click the Format Painter (left side of Home tab). You can paste formatting multiple times. Esc to stop

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.
 

Watch MrExcel Video

Forum statistics

Threads
1,127,082
Messages
5,622,575
Members
415,907
Latest member
Walters87

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