Sorting or Arranging Columns with incorrect Row data


New Member
Mar 6, 2016
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:

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

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


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.


New Member
Mar 6, 2016

Here's the screenshot,

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..


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

Forum statistics

Latest member

Some videos you may like

This Week's Hot Topics

  • VBA (Userform)
    Hi All, I just would like to know why my code isn't working. Here is my VBA code: [CODE=vba]Private Sub OKButton_Click() Dim i As Integer...
  • List box that changes fill color
    Hello, I have gone through so many pages trying to figure this out. I have a 2020 calendar that depending on the day needs to have a certain...
  • Remove duplicates and retain one. Cross-linked cases
    Hi all I ran out of google keywords to use and still couldn't find a reference how to achieve the results of a single count. It would be great if...
  • VBA Copy and Paste With Duplicates
    Hello All, I'm in need of some input. My VBA skills are sub-par at best. I've assembled this code from basic research and it works but is...
  • Macro
    is it possible for a macro to run if the active cell value is different to the value above it
  • IF DATE and TIME
    I currently use this to check if date has passed but i also need to set a time on it too. Is it possible? [CODE=vba]=IF(B:B>TODAY(),"Not...