I think this is a text to columns and then something else. The final result of what I am trying to accomplish is represented below. Letters in LOC1 and LOC2 are not important... random and represent a location. First in cell LOC1 is associated with the first in LOC2... and so on....
<tbody>
</tbody>
Thanks!
Dave
ID | LOC1 | LOC2 | |||||||
1 | a,b,c,d | d,e,f,a | |||||||
2 | d,t,f,r | a,b,c,d | |||||||
3 | a,c,f,v | r,t,e,r | |||||||
4 | r,t,y,w | d,c,b,a | |||||||
1 | a | d | |||||||
1 | b | e | |||||||
1 | c | f | |||||||
1 | d | a | |||||||
2 | d | a | |||||||
2 | t | b | |||||||
2 | f | c | |||||||
2 | r | d | |||||||
<tbody>
</tbody>
Thanks!
Dave