How JustAnswer Works:

  • Ask an Expert
    Experts are full of valuable knowledge and are ready to help with any question. Credentials confirmed by a Fortune 500 verification firm.
  • Get a Professional Answer
    Via email, text message, or notification as you wait on our site.
    Ask follow up questions if you need to.
  • 100% Satisfaction Guarantee
    Rate the answer you receive.

Ask The-PC-Guy Your Own Question

The-PC-Guy, Computer Manager
Category: Microsoft Office
Satisfied Customers: 1830
Experience:  20 years experience providing remote computer support
Type Your Microsoft Office Question Here...
The-PC-Guy is online now
A new question is answered every 9 seconds

We have a similar need for this next one. We want to sort the

This answer was rated:

We have a similar need for this next one. We want to sort the rows by matching Column A to Column C and but keep them aligned so there's blanks in Column C where they don't match. We also need to keep rows in Column A & Column B aligned during this process.
Thanks for using JustAnswer. My name isXXXXX will do whatever I can to answer your question

can you attach a copy of the sheet
Customer: replied 2 years ago.
So what exactly are we doing here?
Customer: replied 2 years ago.

We want the rows in Columns A & B to stay aligned and want Column C sorted to match duplicates in Column A

sorry, I am still not following.

We want to match column C to Column A and put the duplicates in Column D?

Then sort by column D?

or do we want to sort all 3 columns but where everything in a row stays together.

Or did you just want to sort column C? but not sort A and B?

Please explain
Customer: replied 2 years ago.

OK, let me start over. Columns A & B (ESS SKU and Qty) are married. They have to remain aligned. We want to sort Column C so it matches duplicates in Column A. There are more values in Column A than C.


inotherwords you want to take whatever values are in column C and redistribute them so they match column As values leaving blank lines in between.

Did I understand this correctly?
Customer: replied 2 years ago.


Column D now contains the matches.

let me know if you have any other problems.
The-PC-Guy and 3 other Microsoft Office Specialists are ready to help you
I did not hear back from you for a couple of days.

How is this working for you?