Import multiple excel files, transpose data and group everything in a master file
- or -
Post a project like this2486
$$
- Posted:
- Proposals: 11
- Remote
- #1617340
- Completed
Full Stack Mobile /WEB Application Developer|React|NodeJS| MERN| Hybrid Application |AWS
Indore
PHP, Wordpress, Drupal, Magento, Data Entry, Administrative and Technical Support, SEO, Digital Marketing
Kingston
143588614835495390902871023122805012405671384864143742917134031717847
Description
Experience Level: Intermediate
General information for the business: Consulting firm
Kind of development: New program from scratch
Description of requirements/functionality: From a path folder, We need to :
1. Read each excel file, Transpose data from column C so data is not any more in one column but spread accross 1 row and many columns (1 column per field).
2. Import the transposed content into a master file that will list all the data from each file as one new row in the master file.
You'll find attached :
- The original files (1 and 2)
- The master file in which we'd like to import all data from all individual excel files
We should be able to run a program/ macro to import multiple excel files so it can import each data into one new row in a master file.
We'd like to have the work done by June 29th .
IMPORTANT: we are running excel 2007 so the solution should be compatible with it if VBA for example
Thank you,
Extra notes:
Kind of development: New program from scratch
Description of requirements/functionality: From a path folder, We need to :
1. Read each excel file, Transpose data from column C so data is not any more in one column but spread accross 1 row and many columns (1 column per field).
2. Import the transposed content into a master file that will list all the data from each file as one new row in the master file.
You'll find attached :
- The original files (1 and 2)
- The master file in which we'd like to import all data from all individual excel files
We should be able to run a program/ macro to import multiple excel files so it can import each data into one new row in a master file.
We'd like to have the work done by June 29th .
IMPORTANT: we are running excel 2007 so the solution should be compatible with it if VBA for example
Thank you,
Extra notes:
Mathieu D.
100% (15)Projects Completed
13
Freelancers worked with
9
Projects awarded
100%
Last project
4 Jun 2020
France
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
Matt
Is there any guide what column to transpose data intoMathieu D.23 Jun 2017Yes the data that we need are in column C
-
Hi Mathieu,
Can you tell me please how many excel files you want to transpose into the master excel template?Mathieu D.23 Jun 2017There will be around 300 files
445403445399
We collect cookies to enable the proper functioning and security of our website, and to enhance your experience. By clicking on 'Accept All Cookies', you consent to the use of these cookies. You can change your 'Cookies Settings' at any time. For more information, please read ourCookie Policy
Cookie Settings
Accept All Cookies