Combine column values, and then randomize it
If you have Excel 365, try the following formula:
=TEXTJOIN("",TRUE,CHOOSE(SORTBY(SEQUENCE(3), RANDARRAY(3)),$A2,$C2,$E2))
Combine column values, and then randomize it
If you have Excel 365, try the following formula:
=TEXTJOIN("",TRUE,CHOOSE(SORTBY(SEQUENCE(3), RANDARRAY(3)),$A2,$C2,$E2))