Excel Macro To Sort Data into Parent Child

Closed - This job posting has been filled and work has been completed.
Web, Mobile & Software Dev Scripts & Utilities Posted 2 years ago

Fixed Price

Delivery by July 4, 2013

$20.00

Budget

Details

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


About the Client

(4.91) 23 reviews

United States
Miami 05:57 PM

52 Jobs Posted
70% Hire Rate, 3 Open Jobs

Over $10,000 Total Spent
43 Hires, 9 Active

$19.55/hr Avg Hourly Rate Paid
479 Hours

Member Since Aug 6, 2012