Arranging two column's based on one column's details

Hi,

I'm trying to have columns B and C arranged so that the content of B corresponds to A, yet the content of C follows B's original arrangement.
In this example, the content of columns A and B will have exact duplicates of one another to help with the arranging.

Below is an image example on what I'm looking for.

Original:
Aimage.PNG

Result:
Bimage.PNG

As you can see, B (and C following B) has been arranged to correspond to A's content the blanks will be skipped in case there's no content.

Thanks in advance!

Originally Posted by mikeTRON

You would have to determine how to logically relate the columns.

Columns A and B will have duplicate content (but in different order), therefore they will relate.
Column C would follow column B's original arrangement = wherever B goes, C will follow.

Originally Posted by mikeTRON

Yeah seems possible depending on the real data.

Sure .
The real data will have duplicate content between A and B columns, only in different order.

Originally Posted by mikeTRON

So what exactly are you wanting help with?

I could likely show you how I would help with a sample workbook but otherwise I can't offer much help.

I would like for Excel to automatically arrange everything so that the results are as shown in the second picture, and I'm guessing it requires a macro.

Sure. Here you go.
In Sheet 1 I have the BEFORE content, and in Sheet 2 is the intended AFTER content.

Originally Posted by JeteMc

This solution will require a bit of manual manipulation, although I imagine a macro could be recorded to take care of that part.
1) Paste the following formula in Sheet1!D1 and copy down: =IF(COUNTIFS(B$1:B$5,A1),A1,"")
2) Paste the following formula in Sheet1!E1 and double click: =IFERROR(INDEX(C$1:C$5,MATCH(D1,B$1:B$5,0)),"")
The following are the steps that could either be done manually or by recorded macro.
1) Select D1:E4
2) Press Ctrl + x to cut
3) Select B1
4) Press Ctrl + v to paste (a circular reference warning will appear, however the output will be as expected i.e. sheet 2)
Let me know if you have any questions.

Perfect! Worked like a charm!
I'm extremely thankful for your help.