F
fljc
I've got two columns. Column A contains the ID; column B contains a
list of subjects, delimited by comma. For example:
HappyValley A,B,C
What I'd like to do is to break up the list in column B using
text-to-columns, but then turn each list item into a separate row,
paired with the ID from column A. Also, a new column should be created,
and contain the relative position of the subject in the original list.
Thus, the row above should produce:
HappyValley A 1
HappyValley B 2
HappyValley C 3
I'd appreciate some pointers please. TIA.
list of subjects, delimited by comma. For example:
HappyValley A,B,C
What I'd like to do is to break up the list in column B using
text-to-columns, but then turn each list item into a separate row,
paired with the ID from column A. Also, a new column should be created,
and contain the relative position of the subject in the original list.
Thus, the row above should produce:
HappyValley A 1
HappyValley B 2
HappyValley C 3
I'd appreciate some pointers please. TIA.