Combine Data by Row
Hello, I am trying to do the following:Given Product Column and Lot Column, I need to create "Lots in Product" Column so that it combines all the "lots' based on the same product.The final purpose is to get the Tabulate:The X1, X2, X3, X4 does not have to be present in the single cell, this will work as well (whichever is easier):Manually this process is insane when I have a table of thousands of ...