Sorting or Arranging Columns with incorrect Row data

[excelboxnovice]

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.

 

[excelboxnovice]

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.