I have 3 large csv file (310678 rows).
Each file contains components of an assembly. At the moment each component is on an individual line with the Assembly name and description on the same line.
We need to compress the component descriptions (Column G) into one cell, but onto an individual line within the cell so we only have one line per Assembly intead of each Assembly having the number of lines of the components within each Assembly.
It does not matter what is left in the Component part number cell of the line as this won't be used.
I have attached two files showing examples of what we have now and what we would like to achieve.
Hoping for some help! Thank you in advance.
Charley
Bookmarks