Forum Discussion
Merge two tables using formulas only
Hi, I've been doing some Excel exercises recently, but I'm stuck on this one. Is it possible to fill in the table in Sheet1 with information from Sheet2, but without using power query, just formul...
Since you have not specified what you are supposed to get in the Table,, therefore I've used Name to pull records from one to another Table.
Read the instruction and follow, hope this help You !!
I'm having a similar issue, and you've almost gotten to the solution. I'm currently trying to Merge Tables where
Table 1 has a column of IDs, and other columns of data that is irrelevant.
Table 2 has some of the same IDs (no additional IDs to Table 1) and these IDS sometimes are repeated with different information.
This is similar to "Sam" having multiple order of different items.
I would like a table that would combine all of the "Sam" rows into 1 row, where if there is multiple data it would be deliminated, i.e., by a comma.
I've been trying to use the Power Query Editor, but I keep getting an Expression.Error: Evaluation ran out of memory and can't continue. This is very frustrating since I was just upgraded to our most powerful/highest memory Engineering level laptop to be able to perform these type of functions.
Table 1 has a column of IDs, and other columns of data that is irrelevant.
Table 2 has some of the same IDs (no additional IDs to Table 1) and these IDS sometimes are repeated with different information.
This is similar to "Sam" having multiple order of different items.
I would like a table that would combine all of the "Sam" rows into 1 row, where if there is multiple data it would be deliminated, i.e., by a comma.
I've been trying to use the Power Query Editor, but I keep getting an Expression.Error: Evaluation ran out of memory and can't continue. This is very frustrating since I was just upgraded to our most powerful/highest memory Engineering level laptop to be able to perform these type of functions.