Data Expansion

Completado Publicado Feb 27, 2013 Pagado a la entrega
Completado Pagado a la entrega

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.

Excel

Nº del proyecto: #4287087

Sobre el proyecto

5 propuestas Proyecto remoto Activo Feb 27, 2013

Adjudicado a:

codemannz

I have years of experience with Excel.

$30 USD en 1 día
(2 comentarios)
2.4

5 freelancers están ofertando un promedio de $65 por este trabajo

greggfletcher

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.

$100 USD en 1 día
(25 comentarios)
5.9
Evs1

***We exist in world's Top 10 Virtual Assistant & Data Entry Companies*** Please check PMB for complete details.

$40 USD en 0 días
(5 comentarios)
2.9
DirkKlann

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).

$125 USD en 2 días
(0 comentarios)
0.0
alpeshbhatt83

Hello, I have gone through the provided excel & I can solve your issue. Regards, Alpesh

$30 USD en 1 día
(0 comentarios)
0.0