Find Jobs
Hire Freelancers

Create a formula to turn columns into rows in Excel

$30-250 NZD

Completed
Posted almost 5 years ago

$30-250 NZD

Paid on delivery
Our annual sales forecasts are exported from our stock control system in a format where all our customers (about 1100) are in individual rows and their forecast monthly sales are in twelve columns. The job is to create a formula or method whereby this layout is rearranged so that each customer ends up in 12 rows, one for each month. The layout will have three columns for (a) customer name (b) year/month and (c) forecast dollar value. We will supply a dummy spreadsheet to trial the method. The method must be easily applicable to all such spreadsheets, every time the budget is recalculated.
Project ID: 19951391

About the project

38 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
Awarded to:
User Avatar
Hi, I am an expert in Excel and Power bi. I can turn your forecast data into (a) customer name (b) year/month and (c) forecast dollar value. I will automate the process when you have new data in the future It changes to this layout automatically. I will teach you how to do it your self as well. I am ready to start your project. please send me your data or sample data in chat. After I complete your work you can award me. Thanks
$30 NZD in 1 day
4.9 (102 reviews)
6.3
6.3
38 freelancers are bidding on average $106 NZD 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
$180 NZD in 3 days
4.9 (432 reviews)
8.3
8.3
User Avatar
Hello, I’m an Excel expert and I would like to help you with trasposing your data. I can use both formulas or macros. Please check my profile and contact me to discuss further details. Regards.
$50 NZD in 1 day
5.0 (480 reviews)
8.0
8.0
User Avatar
Hello, my name is Cristian, i am Excel/VBA expert. I am in the top 5 of freelancers in this area and i have more than 240 projects successfully completed here. i work alone, i do not have a team or outsource the projects, i do everything, that's why i only take what interests me and i can do it effectively. It is a complex project that requires time and dedication. Look at the comments that employers have left me, that is my greatest satisfaction. Best regards
$100 NZD in 1 day
5.0 (306 reviews)
7.3
7.3
User Avatar
Hi, this is actually pretty common request, and i've done it many times before. In order to be 100% sure i need to see a sample data. I believe i can code this in an hour. Btw this cannot be completed with formulas but it can be with macros (VBA). If you are interested in working with me, please message me and i will explain in more detail. Thanks, Milan
$31 NZD in 0 day
5.0 (602 reviews)
7.3
7.3
User Avatar
Hello, I've written a simple Excel formula that allows transpose data as requested. Please drop a PM if you’re interested. Best regards, Hoang
$30 NZD in 0 day
5.0 (167 reviews)
7.0
7.0
User Avatar
Dear Sir/Madam, I'm happy to help you on this data transformation task. I am an expert in both excel and accounting (CPA+B.Sc+MBA+10 Years experience), and have already developed similar matching templates for business across the world. You may refer my profile to see my reliability, and if you are comfortable with those, you can share the existing worksheet along with the sample. I look forward to hearing from you. Thank u Priyal
$50 NZD in 0 day
5.0 (196 reviews)
6.8
6.8
User Avatar
Hi! Thank you for taking the time to read my proposal, My name is Uriel Baray I am a VBA Excel Expert with several years of experience on the field, if you are so kind to take a look to my portfolio, I have some samples for you there. Please send me a message so we can discuss further details of your project
$50 NZD in 3 days
5.0 (59 reviews)
6.5
6.5
User Avatar
Hello Sir, I can provide you python script as per your demand which will rearrange the layout of spreadsheet as you want. You can use it easily it will work on just one click and very quickly. I am confident that i can exceed your expectations. Please contact me so we can discuss further. thanks!
$150 NZD in 2 days
4.9 (116 reviews)
6.6
6.6
User Avatar
Sir, I am well versed in these kind of jobs and can do your project as per requirement. I have over 12 years of exp/eriences. I am very much able to work on this. ***I am ready to start Waiting to hear from you. with thanks and regards
$88 NZD in 1 day
4.6 (102 reviews)
6.3
6.3
User Avatar
Hi, I can write a VBA script to transform your data in the needed format with one click on a button. Best regards, Florin Enache
$110 NZD in 2 days
5.0 (23 reviews)
5.7
5.7
User Avatar
Hi. Great app writer for your projects. I have writen excel app, macro, vba for many years. I am ready to write your project. Thank you for visiting my profile
$40 NZD in 2 days
4.9 (113 reviews)
5.9
5.9
User Avatar
Hello, I can write a VBA macro in Excel that will process source data and generate the output in the described layout, with 12 rows and 3 columns per client, clients being listed in 12 subsequent rows. It will work on the click of a button. To consider - would you like the macro file to load data from an external Excel file or simply from an existing worksheet within this file? With my macro optimization skills, you can be sure that everything will be processed instantly. Is the operating system Windows or MAC? Best Regards
$50 NZD in 1 day
5.0 (62 reviews)
5.3
5.3
User Avatar
Hi, I can write a VBA programme in your Excel file with "Update" button. When you click on the update button, then the data will be rearranged to the specified layout you described.
$250 NZD in 4 days
5.0 (14 reviews)
5.1
5.1
User Avatar
Hello, I can help you with this project, please send me a message with more detail (the file attached) of it, so I can check it and will start working on it inmediately.
$41 NZD in 2 days
5.0 (38 reviews)
4.3
4.3
User Avatar
Greetings to you, I just read your project description and perfectly understand your requirements. I have more than 10 years relevant experiences and skills needed to successfully deliver the work. I assure you of a quality service and on time delivery and I'm available to work for you on a long term basis if the need arise. My rates are really competitive and negotiable. Kindly drop a message so as to discuss further on the project. Kind Regards, Tanveer
$100 NZD in 3 days
5.0 (4 reviews)
3.8
3.8
User Avatar
Hi there, i understand your requirement and can do the work perfectly using my more than 5 year outstanding experience. if you need a sample work or have any questions please let me know, take my Client's work as my own and takes 100% responsibility of delivering it. can start now your project according to the your guide line with Confirmation.
$50 NZD in 1 day
4.9 (12 reviews)
3.7
3.7
User Avatar
Dear Sir I read your project description and I think I am proper freelancer who you are looking for. I have 7+ years experience on web development and project management. As you see my profile, I am qualified enough to take care of you. Once you hire me, I will start work immediately and devote all my effort and passion. If you need more data about me, I can give you. I would love to work with you, and you will never regret about hiring me. Thanks Best Regards.
$140 NZD in 3 days
5.0 (2 reviews)
3.4
3.4
User Avatar
Yes sir I read the instructions. I am best for the job. Already working on similar projects. Please contact me on chat. I will do it for you. How much time do you have. Please let me know if more details on chat. Already completed many projects
$31 NZD in 1 day
4.6 (18 reviews)
3.8
3.8
User Avatar
Hello, My name is Albert and I have a lot of experience in Excel (including formulas, macros and VBA). I have been an Excel user for many years, I have taken courses and I have learned in a self-taught way all that the courses did not teach me. In addition, I am passionate about programming (Java, C ++, etc) and, of course, I have learned and used VBA many times to adapt Excel files (or Acces) for everything I needed when Excel itself can not do it. In VBA I have done everything: advanced calculation functions, functions to customize the display format depending on each case, simple automated copy and paste functions, etc. I can not specify more about this project because I do not have more information, what I can assure you is that I can do it satisfactorily. Before saying goodbye I wanted to thank you for giving me the opportunity to bid and I wanted to invite you to visit my profile or to contact me. I look forward to any clarification. Thank you very much and best regards.
$250 NZD in 7 days
5.0 (6 reviews)
3.0
3.0
User Avatar
I'm new data entry freelancer but I've 19 years experience in dealing with MS Office and web searching, I can provide free sample and I've the ability to get job done at time , I can do the job according to your requirements. What is the deadline for this task ?, willing to cooperate with you Shaimaa Ali Best Regards
$30 NZD in 1 day
5.0 (3 reviews)
1.4
1.4

About the client

Flag of NEW ZEALAND
New Plymouth, New Zealand
5.0
6
Payment method verified
Member since Mar 25, 2016

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.