I hope you all had a nice Easter Break! I have a bit of an Excel hairy one which I am hoping you maybe able to help with.
I pull data out of our system with just 2 columns Position ID and Position Title.
The Position Title is repeated several times for each position ID linked to it i.e there are 4 position id's linked to the position title Accounts Payable Officer.
With over 4500 position ID's I need a help on a code/macro that will loop through the position titles find the rows that contain duplicates and place all the position ID's of duplicates in the one cell (separated with Alt Enter) next to the first entry and then delete the other duplicates.
I currently have a manual concatenate (in column c) but we can't do this manually every month, it would take me a day to do the whole thing.
Thanks in advance for your consideration!