Find Jobs
Hire Freelancers

Excel - Data held in Sets of Rows need converting to columns

€30-250 EUR

クローズ
投稿日: 9年近く前

€30-250 EUR

完了時にお支払い
An old way of storing data in excel for client records now needs to be re-arranged so it can be imported into a database. as you will see in the attachment the Client records are all stored one on top of another in the first several columns of the spread sheet, this I now know to be a very wrong way of keeping records of clients. I have lots of different spread sheets like this and some contain 100's of client records which I now would like to use in a database system. If you know how to do this I would like to discuss this with you in more detail.
プロジェクト ID: 7735634

プロジェクトについて

27個の提案
リモートプロジェクト
アクティブ 9年前

お金を稼ぎたいですか?

Freelancerで入札する利点

予算と期間を設定してください
仕事で報酬を得る
提案をご説明ください
登録して仕事に入札するのは無料です
この仕事に27人のフリーランサーが、平均€86 EURで入札しています
ユーザーアバター
A proposal has not yet been provided
€100 EUR 2日以内
4.9 (183 レビュー)
7.1
7.1
ユーザーアバター
I am expert, I have completed similar projects before, I will provide sample I will wait for your reply, give me more details , Regards, Sultan
€147 EUR 3日以内
4.7 (362 レビュー)
7.1
7.1
ユーザーアバター
Hi I have checked the attached file. I am a programmer with previous experience of mining data in such peculiar scenarios, I believe after some good effort I will be able to create a script that will be able to pull out data from a file(s) like this. The file looks messy, can you tell me which fields do you want to be re-arranged in a new format? Or if you are looking for manually doing it for full accuracy I can also help. Please let me know the total number of such files and records, and also send your instructions and example output. I will be looking forward to seeing your reply. Thank you. Regards Ahsan
€100 EUR 6日以内
5.0 (43 レビュー)
6.4
6.4
ユーザーアバター
Dear sir, Greetings. I can do the sorting, rearrange the way you want. Just need to put some functions, macros or any other formatting necessary. i can show you sample completed work just now. Thank you.
€39 EUR 1日以内
4.8 (82 レビュー)
6.1
6.1
ユーザーアバター
Hello there, thanks for the project you posted. I have read the project description and I think I will be able to take care of this project. I would like to discuss more about this project. If you consider my bid then please open a chat session for me. I am ready to start immediately after your approval. Thanks.
€250 EUR 10日以内
4.9 (40 レビュー)
6.1
6.1
ユーザーアバター
Hi, I have more than 14 years of VBA/Excel exp and I am expert in this kind of work. I have completed more than 235 projects. Please look at the feedback left by my employers to know more about my work. Waiting for your positive response. Thanks.
€80 EUR 3日以内
4.9 (68 レビュー)
5.8
5.8
ユーザーアバター
Hello, I regularly do similar jobs using excel formulas. Please send one working file and I\ll give you demo. Best regards, Hoang
€100 EUR 3日以内
5.0 (61 レビュー)
5.4
5.4
ユーザーアバター
Hello Dear, Sir/Madam, HERE Ready to start Now!!! I can perfectly do it and interested for this project. I have lot of experience related 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 3日以内
4.9 (88 レビュー)
5.6
5.6
ユーザーアバター
Hola, buenas tardes, cómo estás? SoyJorge de Argentina ysi tenés un momento, por favor mira mi Portfolio para conocer quién soy, mis trabajos realizados y comentarios recibidos.Cómoverás, tengoactualmente casi el 100% de trabajos realizados. Si luego te interesa, podríamos conversar al detalle tusrequerimientos para poder ofrecerte una buena propuesta, y de esa forma, encontrar una estructura que se adapte a la base de datos que quierescrear (o que ya tienes). Esto sería un trabajo de extracción de datos, tarea para la cual estoy capacitado (como verás en mi perfil). Bueno, no más por el momento, si te parece hablamos en cualquier momento. Saludos desde Argentina. Jorge.
€155 EUR 3日以内
5.0 (28 レビュー)
5.2
5.2
ユーザーアバター
Hello, I can create you a macro to solve this problem in the next 2 days, Let me know if you are interested. Thanks
€60 EUR 3日以内
5.0 (53 レビュー)
5.3
5.3
ユーザーアバター
Hi Shrab, my name is Cristian, I have a degree in Business and work with excel every day. I have much experience with spreadsheets, formulas and macros. Check my reviews. They speak for themselves. Best regards
€83 EUR 3日以内
5.0 (53 レビュー)
5.4
5.4
ユーザーアバター
Hi, I have experience in job like this and I can do this job very fast, please contact me for details
€111 EUR 3日以内
4.9 (46 レビュー)
4.8
4.8
ユーザーアバター
Hi, I'll be happy to help you with this project. I take pride in accuracy, timely completion and support within reasonable time after completion. Please feel free to message me if you need to discuss any questions
€157 EUR 4日以内
5.0 (28 レビュー)
4.9
4.9
ユーザーアバター
Hi I have read your job description ... I am highly experienced in this field. I did over 100 similar job perfectly like this one . I can fulfill your requirement . High quality work goes cheap . I assure 100% satisfaction with my work. lets start now . Thanks.......
€250 EUR 5日以内
4.8 (76 レビュー)
4.7
4.7
ユーザーアバター
Having more than 11 years of experience in Banking / finance, article/ebook preparation, writing, Virtual assistance, office administration, Web Research, Scrapping, data compilation, copy typing, social media and Data analysis. I am an expert in MS office, which includes Formulae, Macros (VBA), Charts, Pivot, etc., Also having extensive experience in senior management reporting and I can type 75 wpm (alphanumeric) with 100% accuracy. In addition i am very good in keyboard skills, shortcuts and multitasking. Always willing to learn new things and definitely take additional responsibilities. I will always think out of the box to explore new process improvements and have implemented several in my past engagements. Will surely go into detail to understand the entire flow before doing any task.
€44 EUR 1日以内
5.0 (14 レビュー)
4.0
4.0
ユーザーアバター
Hi there, I have a vast experience in Excel and VBA and would be happy to help you on the project. Best regards, Eugene
€30 EUR 1日以内
4.9 (30 レビュー)
4.2
4.2
ユーザーアバター
hi I know how to correct it. excellent excel skills using formats, formulas and shortcuts. let's start thanks
€30 EUR 2日以内
5.0 (1 レビュー)
3.1
3.1
ユーザーアバター
Hello. The first step to re-arrange your client data is to put all the details in one spreadsheet. It will have columns "Buyer name", "Code", "Address", "ID", "Phones", "Email", etc. with corresponding data in rows. The data can be transferred from old to new form using Excel Macro - the macro will automatically scan all files with old forms and will put the data into one single spreadsheet. Thus you will get masterdata file (plain table). Later plain table can be divided further into logical parts or can be uploaded "as is" to the database. The suggested solution for this current Freelancer project is Excel macro which is described above. Further steps can be discussed separately as well. Please contact me to discuss the details if interested, Thanks Kind regards, Alexander
€50 EUR 3日以内
5.0 (4 レビュー)
2.9
2.9
ユーザーアバター
Hello there, This sounds like an interesting project. Could we discuss more? Let me know if you want to have a quick chat with me. Thanks! Fahmi (from Singapore).
€100 EUR 5日以内
5.0 (6 レビュー)
2.3
2.3
ユーザーアバター
Hello, I have used Excel & Access for the past 10 years and your project is pretty similar to what happened in one company I worked for. Unfortunately, I have difficulties to open your Excel file but I can assure you I am able to take care of this task. Therefore, if you need examples of my previous work on freelancer, please let me know. Best regards, THORUS
€222 EUR 2日以内
5.0 (3 レビュー)
2.2
2.2

クライアントについて

SPAINのフラグ
Palma de Mallorca, Spain
5.0
7
お支払い方法確認済み
メンバー登録日:11月 27, 2014

クライアント確認

ありがとうございます!無料クレジットを受け取るリンクをメールしました。
メールを送信中に問題が発生しました。もう一度お試しください。
登録ユーザー 投稿された仕事の合計
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
プレビューを読み込み中
位置情報へのアクセスが許可されました。
あなたのログインセッションの有効期限がきれ、ログアウトされました。もう一度ログインしてください。