Appending Pairs of Column Data!

M

Mike

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Appending Pairs of Column Data! 1
Appending Pairs of Column Data! 2
How to find matches, pairs of two SUMPRODUCT? 7
help with Conditional formatting pairs of cells 1
conditionally format pairs of cells in columns 1
How does one make a scatter plot where x or y data are blank? 1
How to create all possible pairs from a list of text data 2
Working with pairs of cells 15

Top