I have just two columns of data (TABLE1) that I would like to covert (using functions) as shown in TABLE2
TABLE1 Col A lists Item numbers
Col B lists the Version of each Item in A
TABLE2 lists the Item numbers just once, but the Versions are collated in one cell, separated by a |...