Is there a way to do this number separation in VBA or just with formula Separation worksheet example
S S P P Member Jun 25, 2022 #1 Is there a way to do this number separation in VBA or just with formula Separation worksheet example Attachments SPP Corresponding Separation.xlsx 25.4 KB · Views: 4
S S P P Member Jun 25, 2022 #2 It can be filter as in the example Attachments SPP Corresponding Separation Filter.xlsx 26.1 KB · Views: 1
AlanSidman Well-Known Member Jun 25, 2022 #3 A power Query solution is in the attached. You will need to create a new table with numbers 1 to 101 (per your example). Unpivot the original table and then merge the two tables Attachments SPP Corresponding Separation.xlsx 38.2 KB · Views: 2
A power Query solution is in the attached. You will need to create a new table with numbers 1 to 101 (per your example). Unpivot the original table and then merge the two tables