need a quick help
i have a table, need to consolidate data. 2 columns. first column contains a unique identifier (but with many repeats). second column is subcomponents from a BOM (the unique identifier for each BOM is in the first column). i need a quick way to consolidate the data so each unique identifier from the first row is is only listed once per row, and all the corresponding subcomponents in the second column get propagated as new columns. copy --> paste transpose will take forever, (30k+ rows of data). is there a quick way to do this? screen caps below should help illustrate what i need to do
before:
after:
i have a table, need to consolidate data. 2 columns. first column contains a unique identifier (but with many repeats). second column is subcomponents from a BOM (the unique identifier for each BOM is in the first column). i need a quick way to consolidate the data so each unique identifier from the first row is is only listed once per row, and all the corresponding subcomponents in the second column get propagated as new columns. copy --> paste transpose will take forever, (30k+ rows of data). is there a quick way to do this? screen caps below should help illustrate what i need to do
before:
after: