Is there a more efficient way to do what I am doing? (Merge tables keeping values)
So I have three tables:
And I want to merge them into a table like this one:
As you can see, I want to keep the first column as the unique list of names, adding all the different names from the 3 columns. But I want to grab the 3 values from the different tables. I know the values in the different columns don't match the names, but that is exactly the point since I want to compare the values fro the different names. I don't mind the empty cells either.
So far what I am doing is append the tables into a single one with power query, loading it into a pivot table to stack de names, then adding the three different values and copy paste it without format into a different sheet and then converting it to an Excel table.
It actually works, but I can't stop thinking that this is way too innefficient and annoying and that there is an easier way to do it. Can anyone help with this?
[link] [comments]
Want to read more?
Check out the full article on the original site