Data Expansion

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.

Taidot: Excel

Näytä lisää: sample data, expansion, excel data hand, excel data columns, financial data analysis case study, fill data make money, data set, data manipulation excel make money home, case study data center, case display mortgage payment amount list loan balance interest paid payment term loanuser loop back enter amount make selection, case study examples telecomunication data, data dictionary use case bank, computer pastes print screen instead copied data, data commands freelancer, sample data excel, javascript commands data verification

Tietoa työnantajasta:
( 0 arvostelua ) Las Vegas, United States

Projektin tunnus: #4287087

Myönnetty käyttäjälle:


I have years of experience with Excel.

$30 USD 1 päivässä
(2 Arvostelua)

5 freelanceria on tarjonnut keskimäärin %project_bid_stats_avg_sub_26% %project_currencyDetails_sign_sub_27% tähän työhön


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 1 päivässä
(25 arvostelua)

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

$40 USD 0 päivässä
(5 arvostelua)

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 2 päivässä
(0 arvostelua)

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

$30 USD 1 päivässä
(0 arvostelua)