I am using Excel 2007 (and Google Docs!), and I have a data set of values that I need to associate with itself. In short, I have a column of data:
A B C
I need some trick - be it a function, VBA, or macro - to duplicate that column, and associate every value with every other value. Essentially, generate two columns like this:
A A A B A C B A B B B C C A C B C C
Attatched is an actual example of a data set. I've been mashing my head against this, and figured out a way to make it easier to do manually, but I am struggling and would appreciate whatever guidance can be provided! I have a lot of data sets I need to do this with....
Bookmarks