Excel Macro To Sort Data into Parent Child

Excel Macro To Sort Data into Parent Child

Closed - This job posting has been filled and work has been completed.

Job Description

I have SKU's in one column

I need a macro that will sort by the column into Parent Child hierarchy

1501011300
1501011300-S
1501011300-M
1501011300-L
1501011300-XL
1501011301
1501011301-S
1501011301-M
1501011301-L
1501011301-XL
1501011301-Small
1501011301-Medium
1501011301-Large
1501011301-XLarge
1501011302
1501011302-Small
1501011302-Medium
1501011302-Large
1501011302-XLarge

Currently all Parents are together and all Children are together
1501011300
1501011301
1501011302
1501011300-S
1501011300-M
1501011300-L
1501011300-XL
1501011301-S
1501011301-M
1501011301-L
1501011301-XL
1501011301-Small
1501011301-Medium
1501011301-Large
1501011301-XLarge
1501011302-Small
1501011302-Medium
1501011302-Large
1501011302-XLarge

Open Attachment