1) By using following formula in the cell Q2
=IF($B2&"@"&$C2=$B1&"@"&$C1,$Q1,1+$Q1*($B2=$B1))
copied down for all rows
2) Next in cell R2
=TRIM($B2)&"-"&ROMAN($Q2)&REPT("-"&$D2&" "&$E2,OR($A2="OPTIDX",$A2="OPTSTK"))
copied down for all rows
Here B = Ticker information column
C = Expiry Date
Your Ticker is created in column R
You can use this whole column copy – paste special – Values to other ExcelSheet and take other figures Like O H L C V OI etc to the corresponding columns.