Find Jobs
Hire Freelancers

Rearrange Spreadsheet Data using Excel or Python

$10-30 USD

Closed
Posted about 5 years ago

$10-30 USD

Paid on delivery
Hundreds of people's names are in my spreadsheet, and each name has other information with it. The problem is that it's spread across multiple rows and multiple columns on each of those rows. I want it all on a single row per person. The current spreadsheet: Mickey Mouse Address City State Zip Phone Email Income Job title Spouse Favorite Food Homer Simpson Address City State Zip Phone Email Income Job title Spouse Favorite Food What I need: each person and all their info on a single row! Mickey Mouse Address City State Zip Phone Email Income Job Title Spouse Home Simpson Address City State Zip Phone Email Income Job Title Spouse Furthermore, once you do this for one spreadsheet, I need you to tell me how you did it so that I can do it in the future. Thank you! Once I hire you I'll give you the actual spreadsheet, although it will be FAKE DATA. No personal information or identities will be included. I need this done using either Excel, or Python, but please show me how you did it. That's the important part.
Project ID: 18538447

About the project

45 proposals
Remote project
Active 5 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
45 freelancers are bidding on average $27 USD for this job
User Avatar
Hello, I have gone through your job posting and become very much interested to work with you. I am an expert in this field. I have already completed several projects like this. For evidence you can see my profile. Please visit : https://www.freelancer.com/u/schoudhary1553 I have excellent command over English. I am a hard worker, productive and worthy of your attention I hope, I would be the right candidate for this post. Awaiting an affirmative response from you. Kinds Regards, Sandeep
$100 USD in 2 days
4.9 (496 reviews)
8.4
8.4
User Avatar
Hello! I can create a vba script for you that you can use. You will not be dissapointed, I have a big 33% rehire rate. Thank you!
$45 USD in 1 day
5.0 (368 reviews)
8.1
8.1
User Avatar
Hi there, I have experience of formatting excel files, for that you need notepad & winword help to arrange data. Can u send me sample file? the I can tell u steps.
$30 USD in 1 day
5.0 (199 reviews)
7.6
7.6
User Avatar
"""I am an Excel Expert with Professional experience working with Excel both with Formulas and Macro. Working with complicated formula and Developing Macro programs are part and parcel of my daily work. Completed more than 190+ jobs on Freelancer majority of which was 5 star work. I understand the value of deadline and do not compromise on quality. I believe I can do a great work for you and ensure your complete Satisfaction. I am a Business (MBA) Graduate with major in Finance and MARKETING along with 5 years of experience in different analytical roles. Currently I am working for a MNC as an B2B Analyst Manager.I believe I can do a fantastic work for you if you provide me the opportunity. """
$30 USD in 1 day
4.9 (263 reviews)
7.1
7.1
User Avatar
Hi, Nice to know your requirement. I am an excel vba, vb6 professional and have delivered seventy five excel vba projects in the last one year. Willing to take up your project. Thank you, Regards.
$30 USD in 1 day
5.0 (171 reviews)
6.9
6.9
User Avatar
hey, can u please share ur file in chat?
$30 USD in 1 day
4.9 (276 reviews)
7.0
7.0
User Avatar
Hello, sir. I am expert in both excel and python. I am confident I can exceed your expectations. I can start to work in your project immediately. Please contact me, So we can discuss more over chat.
$50 USD in 1 day
5.0 (68 reviews)
6.0
6.0
User Avatar
Hello? How are you? I have good experiences in "Rearrange Spreadsheet Data using Excel or Python" as you can see my profile for these (Excel, Python). I have been working for 7 yrs in this scope. While we contract and work in our jobs, I will get paid once you have confirmed satisfied result. If I do not deliver satisfied result, I will never get paid from you. We can discuss more details to understand more easily if you have other infos. Hope to work with you. Thank you.
$55 USD in 3 days
4.8 (115 reviews)
6.1
6.1
User Avatar
Hi, I am excel expert. This will be simple for me. You may check my profile for trust me. I am available for start now. and can deliver it asap. Thanks
$50 USD in 1 day
5.0 (90 reviews)
5.9
5.9
User Avatar
I have more than 10 years of experience in advanced excel, VBA automation and data processing. I have successfully completed similar projects, please have a look at my portfolio for details. You can get your work done here with highest quality at lowest price. I accept only once you are fully satisfied with the work done. Looking forward to work with you
$18 USD in 1 day
4.9 (50 reviews)
5.9
5.9
User Avatar
Hello, After reading your project details I believe I'm suitable for this project. As I'm expert on this with more than 7 years experience. Please feel free to contact me. I am looking forward to hear from you. Best regards Feroz
$30 USD in 1 day
4.7 (47 reviews)
5.8
5.8
User Avatar
Hi there I am interested to work on this project. This would be great if you please consider my application. I will ensure on-time delivery and 100% accuracy. Regards Sheuly Previous Work Link Below : https://www.freelancer.com.bd/projects/research/Mobile-Notary/?w=f
$10 USD in 0 day
4.8 (25 reviews)
4.4
4.4
User Avatar
Hello. As per your description the data has a pattern: every entry has 4 rows. In this case it can be easily rearranged into one row. Most simple way is to use a VBA macro in Excel. Please contact me if you are interested. Best regards, Alexander.
$10 USD in 1 day
5.0 (13 reviews)
4.4
4.4
User Avatar
Hello. I have 5+ years of experience with python. I have read you description. I can solve your problem by writing a python script. Hope we can work together.
$30 USD in 1 day
5.0 (13 reviews)
4.0
4.0
User Avatar
Ready to start. ............. Ping please...........................................................................................................................
$28 USD in 1 day
4.7 (18 reviews)
4.3
4.3
User Avatar
Hi Sir, I see you want to play with weird data spread across the sheet. I can help you arrange that using techniques in Excel, as i have been doing for other clients on large scale. I can only assure you about the task once i see the data. For my skills, you can review my profile with the review and projects i have done, and also i can show you the large scale sheets i have made for the clients to manage data. Kind of my favorite task Let's discuss this in chat. I'm available and ready to start work on it.
$30 USD in 1 day
5.0 (4 reviews)
3.5
3.5
User Avatar
hi there, I can do your project. I know Python well. I can code in Spyder and Jupyter. I have Python 3.
$30 USD in 10 days
5.0 (11 reviews)
3.4
3.4
User Avatar
Hello, I have checked the description and I would like to have detailed discussion through freelancer chat before we start. I have good expertise over automation in excel I will be here for any kind of assistance that you might need. Looking forward to your response. Thank you.
$25 USD in 1 day
4.2 (4 reviews)
2.8
2.8
User Avatar
I've never missed a deadline and usually finish work well in advance. I am a proactive and timely communicator who possesses excellent time management skills, is highly reliable for meeting deadlines and IT proficient. Here are some tasks I have extensive experience in and would be happy to help you with: - Content Writing / Article Writing / Ghost Writer - Data Entry/Data Scrapper - Data Convert (Excel, Word, PDF) - Emails / letters/ Essay - Social Media content /eBay - Wordpress - MS Excel - Administrative tasks - Digital Marketing
$30 USD in 2 days
5.0 (3 reviews)
2.2
2.2
User Avatar
Expert Python Developer with expertise in Data Science and Machine Learning with 5 years in relevant industry , have read your requirements and believe can do the task efficiently. Have done many data processing tasks using excel , can deliver it with in a day , would love to work for you Looking forward to more details in chat. Regards, Uzair
$10 USD in 1 day
4.6 (1 review)
2.4
2.4

About the client

Flag of UNITED STATES
Keene, United States
5.0
2
Payment method verified
Member since Nov 25, 2018

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.