The attached excel file contains 2 worksheets.
Problem - Sheet 1:
Column D in Sheet1 contains radio and TV call signs. In many rows there are multiple calls signs, separated by a space.
The requirement is to separate each call sign into its own row and allocate an ID number for that Call Sign. Repeated Call Signs will have the same ID number.
Example solution Sheet2:
Sheet2 shows how the first 15 rows from Sheet1 have been separated into a separate row for each call sign in Column D.
And each different call sign has been allocated a different Call Sign ID number. Where the call sign is repeated, the ID number is repeated.