Completed

Need An .xlsx Magician

I have a single column list of performers (alphabetical) and their releases (not alphabetical). The performers names are in all caps. The release titles are in mixed case. What I'd like is for all of the performers names to be in Column A (alpha) , and the release titles for each performer listed one line down in Column B (alpha).

Example:

Raw data -

Col 1

ALL MIGHTY REJECTS

When The World Comes Down

Kids In The Street

ALL MIGHTY SENATORS

Flow

Raw Power Live

Music is Big Business

Result I want:

Col 1 Col 2

ALL MIGHTY REJECTS

Kids In The Street

When The World Comes Down

ALL MIGHTY SENATORS

Flow

Raw Power Live

Music is Big Business

Note - if organizing Column 2 alphabetically significantly increases the time needed to complete the project, the requirement can be dropped.

There are 4,600 entries in the column.

Skills: Excel

See more: how to import data from excel to sql server, import data from excel to sql server using ssis package, xlsx file opener, xlsx download, sql server import and export wizard does not show excel, ssis excel connection manager no tables or views could be loaded, excel connection manager ssis, import data from excel to sql server using query, do i need an architect to design a childcare center for city to approve surrey bc canada, i need an architect to design a pwf, i need an artist to design a wedding card, i need an artist to paint a copy of a painting, i need an engineer drawing for a new product, i need an engineer to build a security panel, i need an engineer to design a toy, i need an html template for a dashboard on which i have to show some information on a map mainly, need an accounant to do a form 2 not audited in adelaide, need an artist to do a portrait, need an artist to paint a picture, i need an architect to draw a house plan

About the Employer:
( 1 review ) Alexandria, United States

Project ID: #17406193

Awarded to:

ScareCrow01

I can help Relevant Skills and Experience Excel Proposed Milestones $20 USD - Full

$20 USD in 1 day
(18 Reviews)
4.1

19 freelancers are bidding on average $24 for this job

MimiFL

Automating the spreadsheet so that we separate performers names and release titles into two separate columns (instead of a single one). Relevant Skills and Experience I m serious freelancer with 100% completion rate a More

$20 USD in 0 days
(384 Reviews)
6.7
elqueabandona

Hello, my name is Cristian, I have a degree in Business and work with excel every day. I have much experience with spreadsheets, formulas, models and macros. Check my reviews. Best regards Relevant Skills and Experi More

$19 USD in 0 days
(199 Reviews)
6.7
daniyal3214

I am an Excel expert and holding years of experience in utilizing advance level tools of Excel. That is not really difficult project for me and can be done with basic data analysis techniques. Relevant Skills and Expe More

$25 USD in 1 day
(31 Reviews)
5.0
prabakarm23

I have 8 years of experience in .NET, VBA Macros, VB script,PS Script and VB creation with application like SAP, Internet explorer, Microsoft Outlook,PDF& Text files, MS Access and SQL Server Relevant Skills and Exper More

$25 USD in 1 day
(48 Reviews)
4.6
scorpionobaid01

Hi Can we discuss this

$10 USD in 3 days
(16 Reviews)
4.0
haleem0786

i can do this. i have good command over ms excel especially pivot table, chart, advance formulas , data entry etc. Thanks Relevant Skills and Experience Excel Proposed Milestones $35 USD - upon completion

$35 USD in 1 day
(13 Reviews)
3.5
akthar0025

Hello Sir I read your requirements and understand very-well and ready to start work from now. Let's discuss more about project in chat. Relevant Skills and Experience Certified Microsoft Office Application Specialist. More

$20 USD in 1 day
(12 Reviews)
3.1
qasimalikgmail

Dear client, I can write a function for doing this task. The column will be split in two columns. Finally the data will be sorted first by performer name and then by release titles. Looking Forward Relevant Skills and More

$35 USD in 1 day
(5 Reviews)
3.2
tracyjackson11

Manipulation of column data into two columns in Excel, both alphabetically Relevant Skills and Experience I have over 20 years experience in Excel and I would be able to perform your project with the minimum of fuss. More

$25 USD in 1 day
(2 Reviews)
1.9
Saliths

Can get this in 10 to 20 minutes. Thanks! Relevant Skills and Experience MS office intermediate Proposed Milestones $10 USD - Payment

$10 USD in 1 day
(2 Reviews)
1.6
Mrazadata

Hi, I can write a macro to do the work. The macro will be able to separate the data and alphabetise the data. Let me know if you have any questions. Thanks, Misam

$45 USD in 2 days
(3 Reviews)
1.0
fespinozac01

Hello! I have experience working on excell sheet from my bachelor and two energy courses I took in my master. I have spare time and can finish it in one day . thank you! Stay tuned, I'm still working on this proposa More

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

I am going to give efficient result for the work given to me, even it includes 1000 data to be entered i will provide the work in given time Relevant Skills and Experience ِEXCEL Proposed Milestones $30 USD - Urgent

$30 USD in 0 days
(0 Reviews)
0.0
shiva84blu

as I said in my profile , making things right is my specialty Relevant Skills and Experience i like the Job Proposed Milestones $25 USD - .

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

I am an experienced advanced excel user with useful work experience for Addax petroleum. I am extremely efficient, resourceful and very committed to any project I sign up for Relevant Skills and Experience I developed More

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

I have good experience in doing these things in excel

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

I think I will be the perfect choice for you. I ensure you that you will be 100% satisfied with my work. I have excellent Experience- d works Relevant Skills and Experience Typing Speed 40-45 WPM, Copy Paste,MS Word More

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

hello, I'm the magician you are looking for. I have excellent skills of excel with a practical experience of over a decade and half. sit back and relax, job will be done to the dot as required. cheers Relevant Skills More

$10 USD in 1 day
(0 Reviews)
0.0