Alright so once again i have a huge file (a PBOM)
There are many part numbers but some are duplicates with the same exact information
For example there is part number
12345xmb Data Data Data Data
12345xtb Data Data Data Data
12345xcv Data Data Data Data
12346xmb Data Data Data Data
12346xtb Data Data Data Data
12346xcv Data Data Data Data
the art numbers go on like this for about 30,000 cells.
I want to pull only ONE of the three similar part numbers but also grab all the information to the cells next to that row. (maybe there is someway to do this in a pivot table? im not sure)
For example
12345 Data Data Data Data
12346 Data Data Data Data
I feel like i have explained the situation pretty well but let me know if i can clarify.
Thanks in advance!