I have a problem, I need to combine a number of columns within a table based on a suffix. The columns have been created from a collection cell that has been split, so has the suffix _1, _2,_3 etc. I need to combine columns with the same suffix together to form a new column and be able to name these new columns as combined_1, combined_2, combined_3 etc.
How can I do this ?
I have loaded an excel file with an example dataset, so the output should be;
combined_1 (contains all elements with suffix _1)
combined_2 (contains all elements with suffix_2)
combined_3 (contains all elements with suffix_3)
Book1_ExampleDataSet.xlsx (8.8 KB)