Thought this would be easier but need to present data in columns as per this example. Really looking for the simplest way possible to do this so if there are any commands like Find and Replace that would do it, great, otherwise formulae/function and if that is not possible then VBA.
Crtieria map updated.xlsb.xlsx | |||||||||
---|---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | G | |||
1 | Required output | ||||||||
2 | HR | Sales | Admin | HR | Sales | Admin | |||
3 | Tom, Fred | Sally, Ken, Peter | Victor, Steve, Noel, Adam | Tom | Sally | Victor | |||
4 | Fred | Ken | Steve | ||||||
5 | Peter | Noel | |||||||
6 | Adam | ||||||||
Sheet3 |