Matching the data

[workshop]

colum1 colum2 colum3 colum4 colum5 colum6
FA00 FA00
FB00 FB00
FC00
FD00 FD00 FD00

How do I sort the data form the colum1 to colum5 and if the data exist doest not exist more than one (like FC00 in colum1) then delete that entire row...
Please help, my head against the wall. Thank You

 

[ETID]

Could you re-phraze you question...sorry, I couldn't follow?

 

[workshop]

I am trying tosort the data from colum1 through the colum5 to see if there any match (i.e FA00, FB00...) and if there is the match then the data stay and if the data only exist in one colum (any colum) then delete that row
thanks

 

[workshop]

colum1 colum2 colum3 colum4 colum5 colum6
FA00 FA00
FB00 FB00
FC00
FD00 FD00 FD00

How do I sort the data form the colum1 to colum5 and if the data (i.e. FA00, FB00...) appear more than one colum (from 1 to 5) then give the number of time appear in colum6 otherwhy if data appear only one colum (i.e. FC00 )then delete that entire row...
Please help, my head against the wall. Thank You in advance