Lookup / Index / Match Function
 

Hi,

I have a worksheet with the following 4 columns:

Cell A 1 Cell A 11
Cell A 2 Cell B 12
Cell B 3 Cell B 13
Cell B 4 Cell B 14
Cell C 1 Cell B 15
Cell C 2 Cell C 16
Cell C 5 Cell C 17

What I am trying to do is organize them in the following manner across
3 columns:

Cell A 1 11
Cell A 2
Cell B 3 12
Cell B 4 13
Cell B 14
Cell B 15
Cell C 1 16
Cell C 2 17
Cell C 5

So, the idea is that I will have the identifying qualifier (eg; Cell
A, B,C) in one column and have 2 unique lists which have values
related to either Cell A,B,C. I can do this via VBA code using a
While loop and arrays to store the information but I was hoping
someone could help me do this task without code.

Thanks