I was looking for a way to compare two groups of data on the same worksheet
then arrange the two groups of data based on the contents on one column in
each group. These two groups will have at least one row in common that I want
to line up side by side along with their counter part cells.
If a cell in one group matches a cell in the other group i want to line up
all of the other cells in that row of group A with those in group B. If there
is no match then shift all of the cells of the group B data down one row, and
push all of the other rows below the unmatched row down one also. Both of
these groups will have already been sorted on the common data column.
My Goal is to line up all of the data side by side from both groups so i can
see what other cells in that row have different data in them. These groups of
data will have 2 to 3 thousand rows.

Any ideas will be appreciated....Thanks