Hello All.
I'm trying to automate a matrix process. I have two columns in two different tables and I'd like to combine from Table 1 column 1 with Table 2 column 1 (in this case) and outputs it into another sheet essentially creating a master matrix dataset. For instance:
Table 1 row 1:
crpr
rgcj
Table 2 sample rows:
3337
7090
3735
output sheet 2:
crpr3337
crpr7090
crpr3735
rgcj3337
rgcj7090
rgcj3735
Any help or leads would be appreciated!
This is best done using PowerQuery.
Load both Table1 & Table2 into PQ. Go into editor, and select Table1. Add custom column in PQ. "=Table2". Then expand that column.
Select both columns and right click -> Merge columns. Load as connection only.
Back in worksheet, add Sheet2 and activate it. Right click on Table1 (Query) as Table, Existing Worksheet: =A1
See attached sample.
?Progress isn't made by early risers. It's made by lazy men trying to find easier ways to do something.?
― Robert A. Heinlein
Does this work for you ?
Please Login or Register to view this content.
Avoid using Select, Selection and Activate in your code. Use With ... End With instead.
You can show your appreciation for those that have helped you by clicking the * at the bottom left of any of their posts.
Hey guys!
bakerman2's solution was what I was looking for. I initially tried PowerQuery before but didn't like the fact that it loaded so slow. With a small sample set of 100 rows it wasn't an issue but the live dataset will have thousands more so I would have to opt with the macro code. Thanks again!
Glad to help and thanks for rep+.
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks