Sorry, I have written this only referring to the S1, S2 size columns and not also the R1, R2 columns, also I have referred to the S1, S2 columns being in the PO table, rather than the SIZES table. Rather than trying to fix it up hopefully you will be able to understand what I mean, if not please ask and I'll go back and fix it properly, but right now I'm supposed to be heading out
It would be better that all your S1, S2 size columns were actually individual rows in a separate child table. Probably too late to change the database design now?
If it is tedious to write the UNION query, but you need to use it often, you could create a VIEW that includes all the necessary UNIONs and then just query that VIEW when you want the sizes "flattened"
You could create a Child Table, for the sizes, and have a Trigger on the parent table that automatically maintained the Child Table in step. All existing APPs would work, with the original table, but queries could use the Child Table instead, if they prefer.
You could rename the existing table to a "Version2" name and make that the main table, and create a Child Table for the Sizes, and "move" the size data from PO_V2 to the Sizes child table. Then create a view with the original PO table name that flattens the parent / child data back into the original format - again, all existing SELECT APPs will continue to work; but UPDATE/INSERT/DELETE will not work, for them create an INSTEAD OF trigger on the PO View and have that write to the new PO_V2 table and the Sizes child table as appropriate.
All that is quite a lot of work but, if you now decide that a re-design is needed (with the benefit of hindsight) it is possible to implement it with minimal, if any, changes to existing APP code.
P.S. I wonder if you should use "UNION ALL" rather than "UNION". If someone puts "Size 8" in BOTH the S1 AND S2 columns (of the same row) then that is presumably two entries, not one, even if that should not be allowed. (Something else that is MUCH easier to enforce on a Child Table - just put a Unique Constraint / Index on Num, SIZE columns in the new V2 table)