Excel project- Manipulate excel data
Budget: $15 – $25 USD
owse by Category
Manipulating Excel Data (Closed for proposals)
- or -
ENDS IN (DAYS) 21FIXED PRICE £10
(APPROX. $12)
Posted: 1 week ago Proposals: 35 Remote #3603009 OPEN FOR PROPOSALS
Abz T.Wirasat A.Riffat B.Hira H.Sana J. + 30 others have already sent a proposal.
10
Description
Experience Level: Entry
Now closed for proposals - thank you everyone who responded.
This is a one-off exercise to see if this data's reformatting can be done as an Excel macro?
Key expertise is in using Excel, so open to anyone with our without experience.
Please note: Doing this manually is not an option as real versions of this data are far too large and making errors is a serious problem.
-----------------------------------------------------------------------------------------------------------------------------------------------------------------
Attached sample excel spreadsheet has 407 items of data.
The original sheet is Column 1 an rows as ID 'C1' C2' 'C3' and so on.
Column 2 is multiple references 'H12' 'H46' and similar that link with the ID in column 1. This is a 1:many relationship.
ID Col 1 | Link Col2 |
C1 | H12, H46 |
The requirement is to generate a 1:1 relationship where for each entry in Col 2 adds a new entry in column 1.
ID Col 1 | Link Col2 |
C1 | H12|
C1 | H46 |
C1 |and ....more
It converts to a new sheet of around 400 rows instead of 100 rows.
Manipulating Excel Data (Closed for proposals)
- or -
ENDS IN (DAYS) 21FIXED PRICE £10
(APPROX. $12)
Posted: 1 week ago Proposals: 35 Remote #3603009 OPEN FOR PROPOSALS
Abz T.Wirasat A.Riffat B.Hira H.Sana J. + 30 others have already sent a proposal.
10
Description
Experience Level: Entry
Now closed for proposals - thank you everyone who responded.
This is a one-off exercise to see if this data's reformatting can be done as an Excel macro?
Key expertise is in using Excel, so open to anyone with our without experience.
Please note: Doing this manually is not an option as real versions of this data are far too large and making errors is a serious problem.
-----------------------------------------------------------------------------------------------------------------------------------------------------------------
Attached sample excel spreadsheet has 407 items of data.
The original sheet is Column 1 an rows as ID 'C1' C2' 'C3' and so on.
Column 2 is multiple references 'H12' 'H46' and similar that link with the ID in column 1. This is a 1:many relationship.
ID Col 1 | Link Col2 |
C1 | H12, H46 |
The requirement is to generate a 1:1 relationship where for each entry in Col 2 adds a new entry in column 1.
ID Col 1 | Link Col2 |
C1 | H12|
C1 | H46 |
C1 |and ....more
It converts to a new sheet of around 400 rows instead of 100 rows.