Could you let us know what is the format of output that you require ?
Based on this statement, maybe we can assume you have multiple data in a single cell. We would need to identify what is the separator for each of the values present, So that we can perform a Split operation based on that separator.
However, to simply get all the column values present in the row. We can use the below :
Although there is a brief understanding of the logic that is to be performed to achieve this output. We do not the complete explanation as to why you want only the Highlighted values and not -PASM or Optional Extras ?
Could you also maybe provide an Input Excel Data and it’s Expected Output Data for us to confirm on the logic that would need to be applied ?