Find Jobs
Hire Freelancers

Convert Cross Table to Panel Table Data in Excel

€30-250 EUR

Completed
Posted almost 9 years ago

€30-250 EUR

Paid on delivery
I need person who can convert crosstab data to panel data in excel. Screenshot 1 illustrates the basic point. My data right now looks like Blue table (with blanks between rows) and I need it to look as Green table. Second screenshot shows how the actual workfile looks like. My datafiles are large and I need to convert around 40 sheets of data (with data structured a bit differently on each sheet) overall. The person needs to either convert all of it or provide me with elegant decision to quickly do it myself. Vitali
Project ID: 7541585

About the project

25 proposals
Remote project
Active 9 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
Awarded to:
User Avatar
I am a professional data analyst and researcher for the University of California, Berkeley. I would complete the tasks quickly and accurately, and provide you with excellent documentation and results at the end of the project. I look forward to learning more about the requirements!
€99 EUR in 3 days
5.0 (2 reviews)
2.6
2.6
25 freelancers are bidding on average €112 EUR for this job
User Avatar
A proposal has not yet been provided
€70 EUR in 0 day
4.9 (170 reviews)
6.9
6.9
User Avatar
Hello, my name is Cristian, I have a degree in Business and work with excel every day. I have much experience with spreadsheets, formulas, databases and macros. Check my reviews. They speak for themselves. Best regards
€122 EUR in 5 days
5.0 (44 reviews)
5.2
5.2
User Avatar
Hell again, checked your file we may find some solutions using macros and/or a combination of macros and manual work, can you please send me your excel file since I did not know what type of cross tab data is your second screenshot.
€89 EUR in 3 days
4.8 (73 reviews)
5.4
5.4
User Avatar
Hi, I would love to work on this project. I have 8 years of experience in Microsoft Excel including working with excel modeling, dashboards and macros. I can start right now. Please contact with further details if interested. Regards Raghav Bansal
€111 EUR in 3 days
5.0 (47 reviews)
5.2
5.2
User Avatar
Hello, Thank you very much for posting the job. I belong to India. I graduated from India's best university named Indian Institute of Technology (IIT). I have over 7 years of professional work experience and I have been freelancing for over 2 years. I have worked on lot of advance Excel dash boarding and VBA coding and delivered them successfully with high quality. Few of my projects are 1) Fully automated end to end business model for 3B $ healthcare company. Scope : Global Forecast for 8 products, cost modelling, product selection and prioritization, scenario analysis 2) Training Management System for an MNC. Scope : Training calender, TL can nominate his associates to relevant trainings, sends reminders, annual training summaries etc 3) BD&L model for an MNC ; Market analysis, geography analysis, opportunity analysis, SWOT, cost benefit analysis 4) Physician segmentation and Targeting ; Physicians of Latin American were segmented in 3 tiers based on several factors, exhaustive call planning strategy was built with additional features like territory alignments, productive call frequency etc I delivered many more projects of high value and quality. I am confident that I can deliver your project with high quality. Looking forward for your response so that I can start working immediately Thanks and Regards.
€100 EUR in 1 day
5.0 (11 reviews)
5.2
5.2
User Avatar
Hello Dear, Sir/Madam, HERE Ready to start Now!!! I can perfectly do it and interested for this project. Have an experience same and different types of projects. I am waiting to your quick positive reply. Feel free ask me question if any. Have a nice day and stay fine:-) Thanks
€105 EUR in 3 days
4.8 (63 reviews)
5.2
5.2
User Avatar
Hello Sir. I have see your scrrenshot and i think i can do it fast via macro VBA :) please give me a chance for doing your job and im able to start doing your job right now :) please see my portfolio and my feedback ( the most job that has been done is a bout macro Project ) :) Thank You Sincerely Prameswara VBA Macro and Formula Excel Expert
€30 EUR in 0 day
4.9 (46 reviews)
4.8
4.8
User Avatar
Hello, The first part is understandable. I can realize it (using macro) within a few hours. The second part Screenshot 2 - requires explanation. It is not clear to me what to do. Can you write something more on this subject. If you have any questions I will be happy to answer. Best regards Jan Krzyzak
€100 EUR in 3 days
5.0 (10 reviews)
4.0
4.0
User Avatar
Hello Sir/Miss My name is Noman Gulzar and I am a Graphics design Contrator located in Karachi Pakistan. I would love to have the opportunity to interview with you about your posting. I have completed a wide variety of Graphics design projects, samples of which can be viewed on my portfolio All Portfolio link here: https://www.freelancer.com/u/seomaster212.html I work exclusively in the Adobe CC Master Collection for virtually all of my graphics design Projects. In the case of your posting. I would create a design for a cup incorporating the provided logo. I would then provide the work in any formate requested (I highly recommend AI as vector-based images are infinitely-scalable and never pixelate). I always strive for 100% satisfaction from my client and will make as many revision as are necessary to achieve that goal. I encourage you to take a look at my work including some of the other skill sets highlighted on my portfolio site. Thank you for your consideration and I look forword to speaking with you. With Regards, NRWEBSEO
€105 EUR in 3 days
4.8 (8 reviews)
3.8
3.8
User Avatar
Hi there, I have a vast experience in Excel and VBA and would be happy to help you on the project. Best regards, Eugene
€66 EUR in 2 days
4.9 (16 reviews)
3.4
3.4
User Avatar
Hi! I have VBA codes ready for your project. Can you contact me so that I give you some samples? Thanks
€111 EUR in 1 day
5.0 (1 review)
1.1
1.1
User Avatar
Hi it is very simple thing. Just you need to copy it and paste it as special. Very simple thing you can do by your self. If you have doubts i will help you. Don't waste your money unnecessarily. Regards, Bhaskar
€30 EUR in 3 days
5.0 (2 reviews)
1.2
1.2
User Avatar
I am Anbu Joseph from India. I have excellent experience in data entry works and Web researching. I have completed my MCA-master graduate degree in computer applications. Moreover fast typing, excel, Web researching, scraping skills.
€30 EUR in 1 day
5.0 (1 review)
0.6
0.6
User Avatar
A proposal has not yet been provided
€155 EUR in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hi, I can help you with this project. Option is with you. I can do it and send back or I can help you on how to do it. Let me know how you want it. Looking forward for this project.
€30 EUR in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
I faced several challenges developing and improving worksheets at Goodyear Co. and my previously work in China. Therefore, I'm a hard worker expert in Excel, surely I'm the man that you are looking for your project! Bests!
€30 EUR in 1 day
5.0 (1 review)
0.1
0.1
User Avatar
A proposal has not yet been provided
€288 EUR in 7 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Many years of experience and understanding the program itself, creating data sheets to manipulate any action needed, writing formula's as easy as 1 2 3, also experience in the petrochemical industry for populating and designing professional corporate documents, data sheets etc. Branding and designing being my top specialty.
€155 EUR in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
A proposal has not yet been provided
€166 EUR in 6 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Aucune proposition n'a encore été fournie.
€155 EUR in 3 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of NETHERLANDS
Rotterdam, Netherlands
5.0
1
Payment method verified
Member since Apr 23, 2015

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) & Freelancer Online India Private Limited (CIN U93000HR2011FTC043854)
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.