Data Expansion
$30-250 USD
Paid on delivery
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.
Project ID: #4287087
About the project
Awarded to:
5 freelancers are bidding on average $65 for this job
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.
***We exist in world's Top 10 Virtual Assistant & Data Entry Companies*** Please check PMB for complete details.
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).
Hello, I have gone through the provided excel & I can solve your issue. Regards, Alpesh
