This is Python problem,

This is the data that we input. These are the data of the WWE fighter. If the result is 1-0 is mean that 1 win. For example John_Cena vs Big_Show 1- 0 John_Cena win

After analized the data input I need to organized the data. Like the picture below

John_Cena starting index 4 to Index 5 he won against Big_Show and Kane. Starting 6 to 7 he lost the yellow mark mean he lost. Dont need to make yellow mark this is just to make it clear. The brown is mean draw. For example Rey Misterio, 4 is he win against kane, index 5 he lost again kane and 6 he draw against kane.

I did do my own code like this one bellow

The result is like this

As we notice that we only get John_Cena record. How do I make the code loop to each every fighter not just 1. I put "John_Cena" in line 12 because i dont know do i need to make 4 or more empty list.

like for example

superstarlost1=[]

superstarlost2=[]

superstarlost3=[]

superstarlost4=[]

like these? depending on how many superstar are there. or what should i do to do it. to command the computer creating their own list

AutoSave ( Book1 Excel File Home Insert Page Layout Formulas Data Review View9 Tell me what you want to do Cut e wrap Text Calibri General Paste Conditional F Merge & Center $. %, S: Format Painter Formatting Clipboard Font Alignment Number 1 John Cena Big Show 2 Rev Misterio [Kane 3 Big Show Kane 4 Kane 5 John Cena Big_Show 6 Rev Misterio [Kane 7 Big Show Kane 8 Kane 9 John_Cen Kane 10 Rey Misterio (Kane 0 0 ohn Cena 0 0 BigShow 12 Red Fighter Blue Fighter Result Result 13 15 16 17 18