Hi Team, I am scratching my head to randomize the cell contents in different sets with flower brackets and a comma separator
Excel Formula or function or VBA is much helpful. The actual data is Text and not a Numeric values.
Ex: Column A Row 1 ( Full range has around 10k Rows)
1|2|3|4|5|6|7|8|9|10|11|12|13|14|15|16|17|18|19|20|21|22|23|24|25|26|27|28|29|30
Expected Output in column B ROW 1
1.Random Unique values selection and Grouping 5 cell text into one group by comma seperate between each pair
2. If it is not divisible by 5 equally then last set will adjust accordingly with balance left
{{2|4|6|8|10},{1|3|5|7|9},{12|14|16|18|20},{11|13|15|17|19},{22|24|26|28|30},{21|23|25|27|29}}
Excel Formula or function or VBA is much helpful. The actual data is Text and not a Numeric values.
Ex: Column A Row 1 ( Full range has around 10k Rows)
1|2|3|4|5|6|7|8|9|10|11|12|13|14|15|16|17|18|19|20|21|22|23|24|25|26|27|28|29|30
Expected Output in column B ROW 1
1.Random Unique values selection and Grouping 5 cell text into one group by comma seperate between each pair
2. If it is not divisible by 5 equally then last set will adjust accordingly with balance left
{{2|4|6|8|10},{1|3|5|7|9},{12|14|16|18|20},{11|13|15|17|19},{22|24|26|28|30},{21|23|25|27|29}}