Here is a screenshot of the new table with the helper columns unhidden: For the example supplied, this would be 17 columns. These can, of course, be hidden.Īll you need is a number of columns equivalent to the maximum of the numerals in the sets, after each of the original columns of your table. Although you would think a VBA solution is required, it is actually quite simple to do this with formulae, provided you use a lot of helper columns.
