Sorry if that's a bit long winded...Here's how it breaks down.
I've been just hired to an office where they have some cells with several values in them, separated by comma. Something like that:
[TABLE="width: 500"]
<tbody>[TR]
[TD="align: center"]ID[/TD]
[TD="align: center"]Companies[/TD]
[TD="align: center"]Names[/TD]
[/TR]
[TR]
[TD="align: center"]1[/TD]
[TD="align: center"]A[/TD]
[TD="align: center"]Albert, Bob[/TD]
[/TR]
[TR]
[TD="align: center"]2[/TD]
[TD="align: center"]A, B[/TD]
[TD="align: center"]Charlie[/TD]
[/TR]
[TR]
[TD="align: center"]3[/TD]
[TD="align: center"]B, C, D[/TD]
[TD="align: center"] Albert, Charlie[/TD]
[/TR]
</tbody>[/TABLE]
And now I need to list, in another table, the Companies and every ID they are involved with; in another table, all names and every ID they are involved with:
[TABLE="width: 500"]
<tbody>[TR]
[TD="align: center"]Companies[/TD]
[TD="align: center"]ID 1[/TD]
[TD="align: center"]ID 2[/TD]
[TD="align: center"]ID 3[/TD]
[/TR]
[TR]
[TD="align: center"]A[/TD]
[TD="align: center"]1[/TD]
[TD="align: center"]2[/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD="align: center"]B[/TD]
[TD="align: center"]2[/TD]
[TD="align: center"]3[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD="align: center"]C[/TD]
[TD="align: center"]3[/TD]
[TD="align: center"][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
I'm not an expert with Excel, so I'm sorry if it's kinda obvious or easy to do.
Thanks for the help, guys
I've been just hired to an office where they have some cells with several values in them, separated by comma. Something like that:
[TABLE="width: 500"]
<tbody>[TR]
[TD="align: center"]ID[/TD]
[TD="align: center"]Companies[/TD]
[TD="align: center"]Names[/TD]
[/TR]
[TR]
[TD="align: center"]1[/TD]
[TD="align: center"]A[/TD]
[TD="align: center"]Albert, Bob[/TD]
[/TR]
[TR]
[TD="align: center"]2[/TD]
[TD="align: center"]A, B[/TD]
[TD="align: center"]Charlie[/TD]
[/TR]
[TR]
[TD="align: center"]3[/TD]
[TD="align: center"]B, C, D[/TD]
[TD="align: center"] Albert, Charlie[/TD]
[/TR]
</tbody>[/TABLE]
And now I need to list, in another table, the Companies and every ID they are involved with; in another table, all names and every ID they are involved with:
[TABLE="width: 500"]
<tbody>[TR]
[TD="align: center"]Companies[/TD]
[TD="align: center"]ID 1[/TD]
[TD="align: center"]ID 2[/TD]
[TD="align: center"]ID 3[/TD]
[/TR]
[TR]
[TD="align: center"]A[/TD]
[TD="align: center"]1[/TD]
[TD="align: center"]2[/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD="align: center"]B[/TD]
[TD="align: center"]2[/TD]
[TD="align: center"]3[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD="align: center"]C[/TD]
[TD="align: center"]3[/TD]
[TD="align: center"][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
I'm not an expert with Excel, so I'm sorry if it's kinda obvious or easy to do.
Thanks for the help, guys
