Completed

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

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]

Skills: Excel Macros, Excel VBA

See more: transpose duplicate rows to columns in excel, convert multiple rows to columns in excel macro, excel vba transpose multiple columns into rows, excel macro transpose columns to rows, convert columns to rows in excel with formulas, excel macro to convert rows into columns, excel transpose multiple rows in group to columns, how to transpose every 5 or n rows from one column to multiple columns?, update multiple rows php mysql array, excel convert column multiple columns, convert single column multiple columns excel, transpose convert multiple row single column excel, find repeat value column excel vba, convert multiple rows columns columns rows excel, excel convert column list rows, excel convert column multi rows, clipboard value excel macro, visual basic repeat process excel macro, convert single column list multi column excel, excel macro visual basic download combine multiple files tabdelimited single column files

About the Employer:
( 12 reviews ) Tucson, United States

Project ID: #19633096

Awarded to:

MimiFL

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 in 0 days
(25 Reviews)
4.9

18 freelancers are bidding on average $19 for this job

aubrey03

I am an Excel and VBA specialist with a lot of experience in creating complex automation tools, formulas, databases, queries and macros. You may check some of my projects here: [login to view URL] More

$40 USD in 1 day
(38 Reviews)
5.2
paris2785

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 adja More

$20 USD in 1 day
(13 Reviews)
4.6
shahinrahimi

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 c More

$15 USD in 0 days
(7 Reviews)
3.6
arvindronin

Hi mate, do you specifically need a macro? I can write a formula to meet your requirements and can do this in next 15 minutes or no fee.. I can write a macro too, but a formula gives you a better flexibility than the More

$30 USD in 1 day
(4 Reviews)
3.7
nvchien94

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 in 1 day
(13 Reviews)
3.4
sorinacho88

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 in 0 days
(7 Reviews)
3.0
pranjalk2902

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 w More

$15 USD in 1 day
(2 Reviews)
1.1
$25 USD in 1 day
(0 Reviews)
0.0
boscojfelix

Dear Sir / Madame, I have worked on your project and the code is ready to submit. Thank You J Felix Bosco

$15 USD in 1 day
(0 Reviews)
1.5
elishamday18

Hello, I am Elisha Day, I live in New Jersey, and I am an expert in wordpress and website creation and optimization. I know HTML5, CSS3, JavaScript web scraping, PHP, and more. I am also certified in Microsoft office p More

$10 USD in 1 day
(0 Reviews)
0.0
jesramyep

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 in 1 day
(0 Reviews)
0.0
RachitGroup

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 Suppor More

$30 USD in 1 day
(0 Reviews)
0.0
ArturQQ

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 in 1 day
(0 Reviews)
0.0
mrabdulbaki

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 in 1 day
(0 Reviews)
0.0
mramirali321

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 f More

$13 USD in 1 day
(0 Reviews)
0.0
FreelancerTechX

Very easy, I can finish this in 30 minutes *************************************************************

$25 USD in 1 day
(0 Reviews)
0.0
pogodin

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 in 3 days
(0 Reviews)
0.0