Hello All, Hope you are doing Fine.
I have Excel data as shown in the below table. Can anyone help me to get the desired output?
In the above sheet, I have character names from the scene. I need to prepare Character-wise scene numbers for my project. So, by making characters unique I need to create a list of scene numbers.
EXPECTED OUTPUT : (Note: Below output is Just to understand the requirement only but not precisely like this)
I need to get all the scene numbers list for the character.
MICHAEL - E01 SC 01, E01 SC 02, E01 SC 03, E01 SC 05, E02 SC 02, E02 SC 04, E02 SC 06, E02 SC 10
JACK - E01 SC 01, E01 SC 03, E01 SC 05, E02 SC 05, E02 SC 09
ELIZABETH - E01 SC 01, E01 SC 04, E02 SC 01
JOHN - E01 SC 02, E02 SC 01, E02 SC 04, E02 SC 09
SAMANTHA - E01 SC 03, E01 SC 04, E02 SC 02, E02 SC 08
LOGAN - E01 SC 03, E01 SC 04, E02 SC 03, E02 SC 07
EVAN - E02 SC 01
ANGEL - E02 SC 03, E02 SC 07
If there is any way to achieve this, Please help me.
Thanks in advance!
I have Excel data as shown in the below table. Can anyone help me to get the desired output?
SCENE NUMBER | CHARACTER NAME |
E01 SC 01 | MICHAEL |
E01 SC 01 | JACK |
E01 SC 01 | ELIZABETH |
E01 SC 02 | JOHN |
E01 SC 02 | MICHAEL |
E01 SC 03 | JACK |
E01 SC 03 | SAMANTHA |
E01 SC 03 | MICHAEL |
E01 SC 03 | LOGAN |
E01 SC 04 | ELIZABETH |
E01 SC 04 | SAMANTHA |
E01 SC 04 | LOGAN |
E01 SC 05 | MICHAEL |
E01 SC 05 | JACK |
E02 SC 01 | EVAN |
E02 SC 01 | ELIZABETH |
E02 SC 01 | JOHN |
E02 SC 02 | MICHAEL |
E02 SC 02 | SAMANTHA |
E02 SC 03 | ANGEL |
E02 SC 03 | LOGAN |
E02 SC 04 | JOHN |
E02 SC 04 | MICHAEL |
E02 SC 05 | JACK |
E02 SC 06 | MICHAEL |
E02 SC 07 | ANGEL |
E02 SC 07 | LOGAN |
E02 SC 08 | SAMANTHA |
E02 SC 09 | JACK |
E02 SC 09 | JOHN |
E02 SC 10 | MICHAEL |
In the above sheet, I have character names from the scene. I need to prepare Character-wise scene numbers for my project. So, by making characters unique I need to create a list of scene numbers.
EXPECTED OUTPUT : (Note: Below output is Just to understand the requirement only but not precisely like this)
I need to get all the scene numbers list for the character.
MICHAEL - E01 SC 01, E01 SC 02, E01 SC 03, E01 SC 05, E02 SC 02, E02 SC 04, E02 SC 06, E02 SC 10
JACK - E01 SC 01, E01 SC 03, E01 SC 05, E02 SC 05, E02 SC 09
ELIZABETH - E01 SC 01, E01 SC 04, E02 SC 01
JOHN - E01 SC 02, E02 SC 01, E02 SC 04, E02 SC 09
SAMANTHA - E01 SC 03, E01 SC 04, E02 SC 02, E02 SC 08
LOGAN - E01 SC 03, E01 SC 04, E02 SC 03, E02 SC 07
EVAN - E02 SC 01
ANGEL - E02 SC 03, E02 SC 07
If there is any way to achieve this, Please help me.
Thanks in advance!