I have some data to analyze. The source data has aggregated cases with common attributes, but I want to turn them back into individual cases. I have attached some sample data. In Row 2 for example, there were 36 cases (Number) that matched the parameters listed in columns B through H. Do you have any idea of what commands I could give to unSUM the 36 and make each its own case; that is, instead of Case#1, it would turn into Case# 1 -36? There are thousands of cases in the data set, so doing this by hand isn't feasible. Thanks for any help you can give.
Hello, i can split the data quickly and efficiently(the count of the records is of no concern). If you are interested in my bid, please contact me. Best Regards.
Two loops (one nested with the row insert and row copy) would do.
I could write a little generic routine that would do the job for you (on this and future spreadsheets).