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 freelanceria on tarjonnut keskimäärin %project_bid_stats_avg_sub_26% %project_currencyDetails_sign_sub_27% tähän työhön


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)