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.
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
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.
"""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. """
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.
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.
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.
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
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
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
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
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.
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.
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.
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.
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
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