Appending Pairs of Column Data!
 

Hi Everyone,

Say I have pairs of columns as follows:

A B C D E F

Mrr1 acf2 Mrr1 WPP1 acf1 WPP1
Mrr1 WPP2 acf2 WPP1
acf3 WPP1
acf1 WPP2
acf2 WPP2
acf3 WPP2

Contents are dynamic in length, and I want in a separate sheet to
create single pair of columns where contents of all contents above are
appended!

Is there a smart way to do so?

Thanks,
Mike