Find Jobs
Hire Freelancers

Convert Single Column into Multiple Rows at Each Repeat Value with Excel Macro

$10-30 USD

Finalizat
Data postării: aproape 5 ani în urmă

$10-30 USD

Plata la predare
I have an Excel spreadsheet that has a single column A. The column looks something like the attached example Excel spreadsheet where the column has <relation> and several lines below that there is an end point titled </relation>. I need the data to include <relation> and </relation> and everything between those points to be grouped into a single row for every instance where this happens. The Excel column has other data that needs to be ignored if it is not between <relation> and </relation>. In the attached Excel spreadsheet I highlighted the items in red that would have to be ignored by the Macro. I also highlighted the items in green where the <relation> begins. Starting in column C in the example Excel worksheet you can see how I would like the data to look like when they are made into multiple rows. You can use this example spreadsheet for testing that your macro works. I need the macro to search for the key word <relation> and </relation> for start and stop end points when creating a new row. I want the macro to use these key words because I will later edit the macro to search for other key words like <test> and </test> and have the data between these two key words create new rows for me. I searched online for a Macro do to this but the closest items that come somewhat close to what I need are listed below. [login to view URL] [login to view URL]
ID-ul proiectului: 19633096

Despre proiect

16 propuneri
Proiect la distanță
Activ: 5 ani în urmă

Vrei să câștigi bani?

Avantajele de a licita pe platforma Freelancer

Stabilește bugetul și intervalul temporal
Îți primești plata pentru serviciile prestate
Evidențiază-ți propunerea
Te înregistrezi și licitezi gratuit pentru proiecte
Acordat utilizatorului:
Avatarul utilizatorului
I can definitely do that, and i've done many similar projects before without a single problem. As always if you are interested feel free to message me and i will code this for you immediately. Thanks, Milan
$20 USD în 0 zi
5,0 (39 recenzii)
5,3
5,3
16 freelanceri plasează o ofertă medie de $20 USD pentru proiect
Avatarul utilizatorului
Hi, there! My name is Paris, and I was glad to see that you're looking for an Excel developer. According to your brief, you want to have an Excel macro that will take the rows between each relation and put them in adjacent columns in a single row. The attached spreadsheet explains this task in detail and I need no further assistance. I will charge you $20 and can deliver within an hour (a single milestone to release once you're satisfied with the final result). I'm among the most experienced, and skilled Excel, and VBA developers on this platform. I am in the top 3% of the freelancers having completed over 300 projects successfully in six years, and I feel confident in achieving your task as well. You're welcome to visit my page (https://www.freelancer.com/u/paris2785) and get an idea of who I am and what services I provide to my clients. I'm online from 8 am to 9 pm, Athens time (including weekends). I'm looking forward to working with you. Sincerely, Paris Pallas
$20 USD în 1 zi
4,9 (33 recenzii)
5,8
5,8
Avatarul utilizatorului
Hi, Before I give you my introduction, let me tell you I am ready with the macro for your sample and have fully solved and tested what you have asked for. I can share the .xlsm file with you for free if you can chat with me. You can check if the program works to your satisfaction and only then award the project to me. I have included the 2 keywords of <relation> and </relation> in my code, just like you want as you will be able to see. I am proficient in Excel VBA and Python. Although I am new on freelancer.com, I have done lots of automation work in Excel VBA and Python and have built several utility programs in VBA and Python. I can even build sophisticated web scrapers quickly. I have a rich experience of building complex scraping software that can scrape financial statements of any listed company in the USA and India as you can see from my portfolio. I can complete your task in a time bound way to your satisfaction. You can even reach out to me for additional assistance if required after the project is over. My main goal is to provide maximum value for your money. If you hire me, you can rest assured of a 100% commitment to your project. Regards, Pranjal Kothari
$15 USD în 1 zi
5,0 (27 recenzii)
5,1
5,1
Avatarul utilizatorului
hi good day, I'm interested in your project and want to help you with, actually I don't care about the price I'm just seeking for reviews, in my opinion, the macro like this spent you 20-30 but I do like to write the code for you about 15. if you interested we could have quick chat on this. besides the excel file, the task that you want to perform is like HTML files. I have rich experience in coding(Python, Java, VBA, ...), and I do my best to save your time and pocket. Please feel free to contact me. MySkills: • Data Management ..............................{Excel, Matlab} • Programming ......................................{Python, Java, C#, VBA, PHP, HTML} • Web designing......................................{Wordpress} • 2D Graphic ...........................................{Photoshop, Macromedia Flash, ...} • 3D Graphic ...........................................{3dsMax, Blender, ...} • Engineering...........................................{AutoCad, Watergem, SewerCad, Flow3D, Elvis, ArcGIS} • Researching .........................................{Green Energy, Solar cells, WaterManagement, ....} • Translating ...........................................{English, Turkish, Farsi} Services: ? Accuracy ? Customer satisfaction is my first "Priority" ? Time Commitment ? Availability Thanks, Shahin
$15 USD în 0 zi
5,0 (20 recenzii)
5,1
5,1
Avatarul utilizatorului
Hello there, I am an Excel expert and I can create 1 script to do it for you. With 1 button to generate data you need. I can do it for you in 10 mins. Please contact me and I will start working on time. Thank you.
$20 USD în 1 zi
5,0 (29 recenzii)
4,3
4,3
Avatarul utilizatorului
Hello, I can easily create this macro for you. Please give me the go ahead and it will be ready very quick. Kind regards, Sorin
$15 USD în 0 zi
5,0 (8 recenzii)
3,4
3,4
Avatarul utilizatorului
Hello ! I can create vba procedure for this task. Can You provide example of xls file with data in one column ? Thank You. Regards, Alexei.
$10 USD în 3 zile
5,0 (1 recenzie)
0,8
0,8
Avatarul utilizatorului
Very easy, I can finish this in 30 minutes *************************************************************
$25 USD în 1 zi
0,0 (0 recenzii)
0,0
0,0
Avatarul utilizatorului
soy actuario con mas de 25 años de experiencia como consultor independiente utilizando VBA excel en mis proyectos. Ya hice el macro y estoy a su orden para enviarlo
$20 USD în 1 zi
0,0 (0 recenzii)
0,0
0,0
Avatarul utilizatorului
Hello, I read through the job details carefully and I am absolutely sure that I can do this project very well, I have more than 20 years of experience. We Provide - Free ADD-ON with Every Project + 6 Month Support After Project Completed + 20 hrs/day Support available even on Weekends + Development on Our Test Server at Start and will do Migration after all Completed and Approved It's been more than 20 Years that We are Providing Services Here We have Grown from 2 Members to 40 Team Members We have gathered more than 1000 Reviews in The Offline Market, Completed more than 2K Projects Being on the Top Rankings on Freelancer We have Worked on all Sort of Projects being Small, Medium or Long Ping us anytime, we are here for help.
$30 USD în 1 zi
0,0 (0 recenzii)
0,0
0,0
Avatarul utilizatorului
Can help you with your task, fell free to accept, available for next 4-5 hrs, today. Looking simple so it will be fast.
$15 USD în 1 zi
0,0 (0 recenzii)
0,0
0,0
Avatarul utilizatorului
Thats is easy I guess.. If its as easy as I think I will do it for free, just need a good recommendation from you.. I can finish it today.
$10 USD în 1 zi
0,0 (0 recenzii)
0,0
0,0
Avatarul utilizatorului
Project ID: 19633096 HI, I can write the micro for job. Few hints for my view: Prior to run 1. Macro will ask for start <tag> 2. Macro will ask for end <tag> 3. Macro will repeat the same for all occurrence of the start tag. Hope I will get and do this job immediately. Regards M Ramzan
$13 USD în 1 zi
0,0 (0 recenzii)
0,0
0,0

Despre client

Steagul UNITED STATES
Tucson, United States
5,0
13
Metoda de plată a fost confirmată
Membru din dec. 22, 2007

Verificarea clientului

Mulțumim! Ți-am trimis prin e-mail linkul pe care trebuie să-l accesezi pentru a revendica creditul gratuit.
A apărut o eroare la trimiterea e-mailului. Încearcă din nou.
Utilizatori înregistrați Totalul proiectelor postate
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Se încarcă previzualizarea
S-a oferit permisiunea de depistare a locației.
Ți-a expirat sesiunea pentru conectare sau te-ai deconectat. Conectează-te din nou.