• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Corresponding Separation

S P P

Member
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
It can be filter as in the example
 

Attachments

  • SPP Corresponding Separation Filter.xlsx
    26.1 KB · Views: 1
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
Back
Top