Find Jobs
Hire Freelancers

Transpose Cells In One Column Based On Unique Values In Another Column

$10-30 USD

Selesai
Disiarkan hampir 7 tahun yang lalu

$10-30 USD

Dibayar semasa penghantaran
Hello, I have 50 columns in Excel sheet. I want to transpose data based on value reflected in column C. So if Column C has same values in 10 rows in sheet 1 than all data in 5 rows would be transpose to sheet 2. This means than sheet 2 would have 50 x 10 = 500 columns Heading of columns would be constant. Example can be found at [login to view URL] I need this to be done via macro (VBA) Once project would be awarded, I would provide you with header values.
ID Projek: 13946806

Tentang projek

25 cadangan
Projek jarak jauh
Aktif 7 tahun yang lalu

Ingin menjana wang?

Faedah membida di Freelancer

Tetapkan bajet dan garis masa anda
Dapatkan bayaran untuk kerja anda
Tuliskan cadangan anda
Ianya percuma untuk mendaftar dan membida pekerjaan
Dianugerahkan kepada:
Avatar Pengguna
Hi there, I have a vast experience in Excel and VBA and would be happy to help you on the project. Best regards, Eugene PS. Windows only.
$15 USD dalam 0 hari
5.0 (262 ulasan)
6.6
6.6
25 pekerja bebas membida secara purata $21 USD untuk pekerjaan ini
Avatar Pengguna
With respect to this project I would like to present myself as a candidate for your consideration. I have more than 7 years of IT experience. I have successfully completed few projects for US clients which involved web scraping, web research,internet research and data entry. Key features of my work are as follows: 1) Always within schedule 2) Always within scope 3) High quality data 4) Best tools and techniques used for the completion of tasks Looking forward to hear from you. Regards
$35 USD dalam 1 hari
4.8 (66 ulasan)
6.0
6.0
Avatar Pengguna
Hi, I have a university degree in economics and IT, and several decades of system design and programming, in the recent decade especially in Excel and VBA. I plan to complete the project via writing an Excel macro contained in a separate XLSM file. This approach makes further use of the macro very convenient by offering a Control sheet containing cells populated by the usual Open file and/or select folder dialogs to identify the current input and output files (or the folders containing them, as required by the job) and hosting command buttons and other controls if necessary. In my approach you'll have opportunity to consult details with me, to test pilot solutions if necessary in order to achieve an optimal final solution. Further use of macros, fixing of bugs and minor changes are included in the bid without any additional fees. I can start working on the project immediately and complete the job within some hours. Regards
$25 USD dalam 0 hari
4.9 (64 ulasan)
5.7
5.7
Avatar Pengguna
Its not time taking task for me, I already have done many /Projects/scripts/scraper like this. I can make code/scraper of your project in just 4 hours and deliver your project within one day I can start your Project right now, I am ready to start, award me the project.
$30 USD dalam 0 hari
4.7 (32 ulasan)
5.9
5.9
Avatar Pengguna
I have the expertise in Excel VBA and can do this task, as per requirements, quickly and accurately. Ready to start work immediately.
$26 USD dalam 1 hari
4.6 (70 ulasan)
5.4
5.4
Avatar Pengguna
asalamo alikom, hello, sir . it is very easy job for me . i can finish it in 1 hour i can write the VBA macro to transpose the data as discussed on the link you sent waiting your answer on chat Regards
$10 USD dalam 0 hari
4.9 (68 ulasan)
4.8
4.8
Avatar Pengguna
I have a bachelor degree in IT. My Primary skills include Java, Python, VB/.NET, ArcGIS, and PHP. Also database skills include MS Access, MySQL, and Oracle. My Other skills include server and network administration and maintenance with Linux/Unix and Windows Networking.
$30 USD dalam 2 hari
4.9 (36 ulasan)
4.8
4.8
Avatar Pengguna
Hi sir, I have seen your attached image and I can able to do this using vookup to complete firstly. SO If you interested then I want to meet with you. I will wait for your reply. Thanks. Shahidul.
$25 USD dalam 1 hari
4.9 (13 ulasan)
3.9
3.9
Avatar Pengguna
Hi , I could finish your request just in a hour . High quality guarantee.
$14 USD dalam 0 hari
4.7 (15 ulasan)
4.0
4.0
Avatar Pengguna
I can do it with perfection. you may like to see review my previous employers. Thank you so much for ur valuable time
$10 USD dalam 1 hari
4.8 (6 ulasan)
3.1
3.1
Avatar Pengguna
Hello, Give me your file. Let me understand it better and if I am able to complete the work i'll let you know and you can offer me the project. Thanks. PM me with more details
$10 USD dalam 1 hari
5.0 (3 ulasan)
0.4
0.4
Avatar Pengguna
i can finish this project quickly this is very simple to me i have experience in microsoft office...
$15 USD dalam 1 hari
0.0 (0 ulasan)
0.0
0.0
Avatar Pengguna
Hello Sir, I read your project details and able to work with your project , I can delivery your work on time so you can hire me to get a Quality Service. Thanks.
$15 USD dalam 1 hari
0.0 (0 ulasan)
0.0
0.0
Avatar Pengguna
A proposal has not yet been provided
$15 USD dalam 2 hari
0.0 (0 ulasan)
0.0
0.0
Avatar Pengguna
Respected Recruiter, I am writing in response to the above mentioned job requirement. I have read your job details and I can assure you that I can complete the work before the mentioned time Please find below the brief description about my Education and Technical Expertise: I have done Bachelor of Engineering in Computer from the top most reputed university in India. I was university topper. My work experience during the last 24 months in Data Analytics Firm includes supporting world largest Retail Giant in improving performance and optimizing processes all-round the globe. I have worked hands on on Microsoft Excel, VBA, Web Scraping using VBA, Tableau and SQL. I have advanced level knowledge of Excel which comprises of: • All basic Excel formulae • Array Formulae, Conditional Formatting • Creating dashboards and charts in excel • Pivot Tables and Pivot Charts • Using Excel VBA for automation of the repeated process • Linear Regression Analysis, Time Series-Moving Average Analysis, t-Test, z-Test, ANOVA Analysis etc using Excel Also, I have created many different Macros in Excel to automate the entire process of Raw Data transformation to user understandable form. The macros that I have created, works as follows: The macro normally starts with pasting the raw data in Excel sheet from Data Server, like SQL, ACCESS etc. After getting the raw data from the server, macro performs the data transformation such as rolling up of data to higher level etc
$18 USD dalam 1 hari
0.0 (0 ulasan)
0.0
0.0
Avatar Pengguna
I am expert vba lead in very big MNC and have 10 years of experience in these solutions. I will give you a solution which not only do the job but will be scalable, maintainable and convenient to use. Thanks.
$20 USD dalam 1 hari
0.0 (0 ulasan)
0.0
0.0
Avatar Pengguna
Hi, I'm an electronic and computer engineer with expert knowledge of Microsoft Excel and VBA programming. I'm very interested to work on your project. I can assure You that, if You choose me, the project will be done in specified time frame and it will met quality recommendations. Thank You, Goran Hristov
$25 USD dalam 3 hari
5.0 (2 ulasan)
0.2
0.2
Avatar Pengguna
I offer my services for an excelent execution thanks to my high experience in creating data bases with Excel.
$25 USD dalam 5 hari
0.0 (0 ulasan)
0.0
0.0
Avatar Pengguna
Hi , I can help you to finish this work with a high accuracy, short time and low cost Please contact me to discuss more details Thank you Best regards
$20 USD dalam 1 hari
0.0 (0 ulasan)
0.0
0.0

Tentang klien

Bendera PAKISTAN
Lahore, Pakistan
5.0
48
Kaedah pembayaran disahkan
Ahli sejak Ogo 25, 2013

Pengesahan Klien

Terima kasih! Kami telah menghantar pautan melalui e-mel kepada anda untuk menuntut kredit percuma anda.
Sesuatu telah berlaku semasa menghantar e-mel anda. Sila cuba lagi.
Pengguna Berdaftar Jumlah Pekerjaan Disiarkan
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Memuatkan pratonton
Kebenaran diberikan untuk Geolocation.
Sesi log masuk anda telah luput dan telah dilog keluar. Sila log masuk sekali lagi.