I have data in a table organised as follows:

```
ID, name1, name2, name3, name4, name5, name6

```

Sample data 

```
select ID, name1, name2, name3, name4, name5, name6
from datatable

123, bob, mark, jane, bob, jane, fred  
124, mark, mark, mark, bob, bob, bob

```

and I need to end up with something like

```
123, bob,  2  
123, mark, 1  
123, jane, 2  
123, fred, 1  
124, mark, 3  
124, bob,  3  

```

Where the count is the number of times a name appears in the record. Is this possible?