Excel Expert - Format/Import Text List Into Excel File

I have a text file ([url removed, login to view] , attached) with information for a large ballot (Meta-Categories, Categories, Sub-Categories, Ballot Items). I have cleaned it up, in terms of making sure things were in the right places, spelled correctly, etc. I have added *** to the beginning of any meta-categories, to make them easier to find. Categories are separated by a row of dashed lines. Sub-Categories (the islands) are a little trickier. There are 3 islands, but not every category has items for each island. Also, some ballot items have the name of an island within their name (although the sub-categories/islands are on lines by themselves).

I need someone to take this information and put it into an Excel spreadsheet, then assign ballot codes to each ballot item (more on this in the next paragraph). Each category needs to have a ballot item, called "Write In", as its' last ballot item. I have attached a file called [url removed, login to view], showing how I want the spreadsheet formatted. Each row of the spreadsheet needs to have all information for its' corresponding ballot item (Meta-Category, Category, Sub-Category, Ballot Item, Ballot Code).

Ballot codes are determined by applying the following rules:

1st digit represents the island (1 = St Thomas; 2 = St John; 3 = St Croix)

2nd, 3rd & 4th digits represent the category number

5th & 6th digits represent ballot item number within the category

So, if a ballot item were in the 347th category, on the island of St John, and it were the 12th ballot item within the category, its' ballot code would be 234712.

I am certain there is a way to easily complete this task using a script or macro, but that is beyond my skill level in using Excel.

Taidot: tiedonsyöttö, tietojenkäsittely, Excel

Näytä lisää: import text list excel, excel list expert, expert import, format list excel, expert format excel, expert format, skill categories, make data entry easier, how to expert in excel, how to be an expert on excel, how to be an expert in excel, how to be an excel expert, find an excel expert, file excel expert, excel macro how to, excel expert up, skill list, how to find an expert, how to be expert in excel, xlsx, thomas, thomas i, skill level, need a excel expert, name format

Tietoa työnantajasta:
( 21 arvostelua ) Geneva, United States

Projektin tunnus: #1697180

Myönnetty käyttäjälle:


I am interested in your project.

30 $ USD 1 päivässä
(28 arvostelua)

29 freelancers are bidding on average $122 for this job


We have done similar project, Pls Check PM

35 $ USD 1 päivässä
(206 arvostelua)

Hello, Excel VBA expert here. Please check PM for details. Thanks!

50 $ USD 1 päivässä
(59 arvostelua)

I think the process can be automated, but i have some questions. I am not sure that i understand the project completely.

50 $ USD 0 päivässä
(26 arvostelua)

Such jobs are my daily practice. I can complete the job within some hours if it's that urgent. Further use of macros (if it's a repetitive job), fixing of bugs and minor changes are included in the bid without any addi Lisää

60 $ USD 1 päivässä
(39 arvostelua)

It will be done within the same day after we officially start. Parsing various data structures is one of our core strengths.

120 $ USD 0 päivässä
(21 arvostelua)

Hi, No problem at all. Please check Feedback and don't close this in the next hour or so . I'll get back to you. Regards David

45 $ USD 0 päivässä
(23 arvostelua)

Dear Sir, We are ready to start and fulfill your requirement. Please check your inbox for details. Regards Rajaa

50 $ USD 1 päivässä
(19 arvostelua)

******* DONE ************ Please check PM...

30 $ USD 1 päivässä
(20 arvostelua)

Hi, I am very interested in your project. Kindly check PM. Many thanks.

30 $ USD 1 päivässä
(12 arvostelua)

Script created.

30 $ USD 0 päivässä
(6 arvostelua)

Hi, please read PMB for my further detail. Thanks.

30 $ USD 1 päivässä
(2 arvostelua)

I 'm new freelancer, but with regard to excel, I think really capable to do this job.

50 $ USD 1 päivässä
(0 arvostelua)

Expert in excel ready to automate your project. Additional details sent via PM.

50 $ USD 1 päivässä
(0 arvostelua)

more details

1250 $ USD 10 päivässä
(0 arvostelua)

To Project Manager I am writing to you because I believe my training, experience, and proven ability as & Data Analyst/Entry will allow me to significantly contribute to your company. you will note that I have acqu Lisää

80 $ USD 1 päivässä
(0 arvostelua)

Dear Sir, I ensure that I will do this job in time with efficiency.

30 $ USD 4 päivässä
(0 arvostelua)

I will try my best to work according to your requirments

250 $ USD 5 päivässä
(0 arvostelua)

Hi I have number of years experience to develop excel based macro for data analysis. Recently i have developed a large macro for Transport For London using Excel, VB to support their on going data anlaysis ( Cost 7 Lisää

75 $ USD 2 päivässä
(0 arvostelua)

Hi, I'm interested in the job and would love to know all details about it. Please let me know, i'm ready to work! Regards, lukman

100 $ USD 1 päivässä
(0 arvostelua)

Dear Hiring Employer, I have read the entire job description and I am interested with the task.

150 $ USD 3 päivässä
(0 arvostelua)