I am using Office 360 (Excel) and I have a csv file with the following headers (and corresponding data):
First Name,Last Name,Address,City,State,ZIP,Phone,Home Owner,Source
The printing company I am using requires the following headers:
Record Id,Salutation,First Name,Middle Name,Last Name,Name Suffix,Title,Business,Address 1,Address 2,City,State,Zip
So I need a script written that will allow me to easily merge the first file data with the appropriate field headers in the second file.
The fields that will need to be completed is the Record ID (1,2,3,4, etc). The data columns (fields) that need to be merged with the second excel file are:
First Name,Last Name,Address,Address2,City,State,Zip
let me know if you have questions
Hello Sir,
I am a full time freelancer and can work dedicated on this till completion. My name is Jay and I am an Expert Techno-Functional Analyst having vast experience in lots of arenas of IT industry including Excel Macros and Formulas. I am an Engineering Graduate with an MBA degree. If you see I am among niche bidders who have 0 failed projects and 100% completion rate since I do not bid on projects which I am not certain of. I will not disappoint you, please give me an opportunity to work with you. No milestones required. Pay me only when your job is 100% done.
Also I will provide you with a sample file before you consider awarding me the project. Please initiate a chat so we can discuss on this.
Thanks,
Jay
Dear Employer,
Please message me. I will create an excel solution which will merge data from first file with the data in second file and will give the IDs for all.
Do check my reviews for your reference.
Thanks and Regards,
Ash
This is Vibrant Webtech and I was glad to see that you're looking for help for project Excel Merge . I've delivered more than 400 + projects in the last 5 years and this makes me very confident with your task.I'd like to have more details before proceeding. This way I'll have the chance to elaborate m bid accordingly. I never ask for payments in front. I will only ask you to release the agreed milestones once the task for each one of them is met and you're happy with it. Feel free to visit my personal page on this platform and get an idea of how satisfied my clients are from my work. Don't hesitate to contact me. I'm looking forward to hearing from you soon.I have more than 5 year of experience in Data Processing, Excel, Software Architecture, Visual Basic. Please ping me for more discussion.
Dear Client,
We are interested in your project and ready to go for it. We have read your job description carefully and understood the project.
We have done similar projects so confident to handle this project. You can check our profile and reviews and hope you would consider us for your project.
We look forward to hearing from you.
Kind Regards,
Safeer Ali
Eagles Inc.
Hi,
I have good Microsoft Excel skills with years of experience as well as I have complete number of projects for Excel to manage data and sorting. You can check my profile feedback section and you will know what my client asking for my work.
I am Alison certified for Microsoft Office and Microsoft Excel. So, you can Trust me for a Best output with complete satisfaction.
Your work will be delivered well in advance with seamless communication & timely response until project is completed. As well as for any alternation and query we are available 24 x7.
Looking forward for great business deal.
"
Hello!
My name is Paris and just had the chance to read your project's brief. I was very excited that you mention Microsoft Excel because this is my favorite field and MS Excel projects are among the tasks I work with regularly and know exactly how to handle them. You mention that you need somebody to transform the csv file in another format (rearranging columns). I'm going to spend less than 1-2 days to complete your project including required revisions for a total payment of $150. I never ask for any payment in front. I claim the milestone release once the project is completed and my client is happy with the result. I'm a very experienced and skilled MS Office developer as you can easily check for yourself. You're welcome to visit my personal page on this platform and get an idea of who I am and what services I deliver to my clients. I'm looking forward to hearing from you.
Sincerely,
Paris Pallas
Hi,
I can provided you with an Excel macro based solution to automatically merge the data from the csv file to produce the desired output. Kindly confirm and provide relevant sample file for testing.
Thanks,
Arul
Hello, i m serious freelancer with 100% completion rate and i believe i can help you. I've done hundreds of merge/conversion projects without a single problem. If you are interested in working with me, please message so we can go over everything that needs to be done.
Thanks, Milan
Hello?
How are you?
I have read your brief description.
I have good skills in excel ... job...
So I think we can work together.
Hope to work with you.
Thank you.
Hello, my name is Cristian, I have a degree in Business and work with excel every day. I have much experience with spreadsheets, formulas, models and macros.
Check my reviews, they speak for themselves.
Best regards
Hello,
I can do your job using power query instead of script which has a lot of troobleshooting. I have advanced excel skills and over 8 years in the field and i can deliver you quality work really fast Please check my portfolio to see my work.
Thanks!
Hello there,
This looks feasible and I can do this quickly.
I have developed more than 500 VBA macros for Windows/MAC
I am an expert in Excel/Word/PowerPoint/Outlook VBA/Python with over 5+ years of experience.
Ping me to discuss project , timeline and budget.
Thanks
A
I am proficient with excel macro/VBA development, I can write the macro to merge files as requested, if you are interested feel free to message me. I do have questions to clarify some details of your specification, looking forward to chat further for a turnaround solution and work on your project
Hi I am a very experienced statistician, data scientist and academic writer. I have completed several PhD level thesis projects involving advanced statistical analysis of data. I have worked with data from several companies and have done projects involving high level quantitative analysis and data interpretation skills to study the trends, time behaviour and compare the variables in the data. I can do advanced level analysis in SPSS, R, PYTHON, WEKA, TABLEAU and EXCEL tools like machine learning, hypothesis testing, forecasting, T-test, ANOVA etc.
Looking forward to discussion,
Best Regards,
Suyash
Hello there, as an expert in excel and VBA, i can help you to accurately develop such a script for your data merging as you have specified. Please contact me and let us talk more about your project. Thanks
Hi, there
I hope all's well with you.
I see you'r looking for a developer proficient in Ms Excel/VB.
Really all my projects here I've developed for Ms Access/Excel/VB
projects.
In your current project needs ADO/SQL vba coding within Excel- I'll ode that.
I'll do your current Ms Excel macro enabled project very professionally and on time.
Here is my introduction:
I’m a ms Access/Excel/VB programmer, a mathematician and a full time
developer with a strong background developing a wide range of accounting,
economical, statistical and mixed type projects using Ms Access, Ms Excel,
VBA, ADO, SQL , including projects for start-up companies and small businesses.
For over the last 20 years I’ve worked in a variety of industries.
I have a deep passion for coding and guarantee that all of developing is 100% original.
I highly value professionalism and hold myself strictly accountable to represent my client’s
brand. I aim to form a long-term working relationship.
Please, let me know what is needed to secure this bid!
Thank you for your consideration.
Zura
Hello,
I can build the macro for you.
At the press of a button you will select the first and second file and the code will do everything you need.
I will also add a settings tab for you to change the headers yourself if the data format will change again in the future.
Please open a chat with me so we can discuss more details.
Kind regards,
Sorin