Excel Rows Mixed up in wrong Columns, need to fix

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: [email protected]

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.

@ steve.smith, pictures are pretty much impossible to edit, and no-one wants to re-type the data
Also, not all members can upload picture files (Company firewalls and stuff) - and, depending on what browser is being used, some pics dont even show up on the forum

For those reasons, we prefer to ask for a small desensitized example of the data the OP is working with and a manual mockup of the expected results.

excelboxnovice looking at your sample, that is indeed a mess

Where is this coming from and how do you get it?

Mt reason for asking where it is coming from, is that perhaps there is a better way to get it, so it is not so messed up.

"Fixing" this with formulas is not going to be easy

I have asked for more help on this

Hi excelboxnovice

Attached is a VBA solution. CTRL + x will fire the Code.

Please Login or Register  to view this content.