Convert a single column of excel data into rows and columns

Completed Posted 1 year ago Paid on delivery
Completed Paid on delivery

I have 2 excel sheets, each with about 4000-5000 customers. However each file has about 30,000 rows because all the customer info is in column A. I need column A which contains all the data to be pivot tabled into rows and columns so I have name, address, phone, email, etc in separate columns. I attached a subset of the data so you can see what kind of data cleanup is needed.

Excel Data Entry Data Processing

Project ID: #36293587

About the project

56 proposals Remote project Active 1 year ago

Awarded to:

(290 Reviews)
7.9

56 freelancers are bidding on average $92 for this job

AishaAlimuhammad

Hello, I can accurately clean up the data by separating column A into separate columns. I am Microsoft certified excel specialist and can work with advanced excel formulas, functions and VBA. Lets discuss the project f More

$100 USD in 3 days
(416 Reviews)
9.0
omersodai

Hi, I can do this work efficiently. I have done many similar projects please see my profile/resume for work history. I assure you that work done will be according to your requirement. I am ready to start work immediat More

$60 USD in 7 days
(164 Reviews)
8.2
hdlong66

Hello Eric, I can assist you to rearrange your raw data of 4,000-5,000 customers into their proper fields like Name, Company name, Address, etc. These are some of about 200 my projects https://www.freelancer.com/projec More

$98 USD in 2 days
(193 Reviews)
7.2
daniyal3214

Hello, Excel expert here. I can perfectly assist you with this and can start on an immediate basis. I am an experienced Excel professional with years of experience in all the tools of Excel including Visual Basic, Auto More

$40 USD in 1 day
(227 Reviews)
7.2
Umerfarooq92912

Hi, I have read your project description carefully and understand. I can help to complete your work as per your requirements. We already completed similar project with good review. Kindly message to me for start thi More

$80 USD in 1 day
(131 Reviews)
6.5
simonklemp

Hello Eric, I hope this message finds you well. I will be able to help you with your project. I read through the description and it sounds like I am just the right person for it. I have the right skill More

$200 USD in 3 days
(22 Reviews)
5.9
ghammo786

i can convert single columns into rows and columns as per your requirement i am professional in ms excel and i can do this job

$30 USD in 2 days
(66 Reviews)
5.6
Ibrahim33

Hello there, I am an Excel expert as I have 5+ years of experience in Excel. I understand your project description. I have reviewed the attached excel sheet and I can do this task for you. Message me now to discuss mor More

$140 USD in 3 days
(61 Reviews)
5.7
Softeria

I am a Data Scientist. I have 7 years of experience working as a Data Analyst. I can analyze your data in Excel. I can create Custom Scripts/automation in Excel. I can create extensive custom formulas, Dynamic Dashboar More

$100 USD in 2 days
(24 Reviews)
5.1
Omar0a

Bro i saw your file...why will u choose me ? Because 1- i have complete tram of 4 professional freelancers who know each detail on excel and can do all your columns tasks easily 2- we can start immediately beforebaward More

$30 USD in 1 day
(59 Reviews)
5.1
umairnoor32

Hello Sir, I have read your instructions and I can do it efficiently according to your requirements. Please give me this project and get 100% extra ordinary work with unlimited revisions even after completion of the w More

$30 USD in 1 day
(47 Reviews)
4.1
habib1433

Hi, I will cleanup and format the excel sheet with pivot table format. So please message me for further discussion. -Habib

$70 USD in 3 days
(20 Reviews)
4.2
MahmoudRafatAli

Hello I read your project and I am ready to start working now I am expert in data entry and Excel Lets discuss the details on chat

$30 USD in 1 day
(31 Reviews)
3.8
kalapani

Greetings, Thanks for the project. I carefully read your project description & I can handle this in my best care and professional manner. I have sound knowledge in Excel. Please give me a message immediately to discu More

$50 USD in 2 days
(4 Reviews)
3.8
FardinkhanBoss

Greetings, I’m willing to provide you with a FREE SAMPLE in this way you will be able to trust my quality work. My bid amount is negotiable and we can discuss it over chat. Are you looking for niche-targeted Business More

$250 USD in 7 days
(5 Reviews)
3.8
Josephhekal

Hello, I could help you Immediately to convert the single column of excel data into rows and columns, and will complete the work as per requirement ASAP. I am an Excel Expert. Have a wide range of technical competenc More

$30 USD in 1 day
(22 Reviews)
3.7
writerLanguage

Dear client, I can assist you with your data entry project. My skills include Excel, copy typing, data entry, and data processing. I provide creative, proactive and high-tech solutions to your development needs. I hav More

$30 USD in 1 day
(6 Reviews)
3.2
MohammadKassem01

Hello, I'm Mohammad. I'm Python/Web Scraping/Automation Expert. I’ve reviewed your requirements and checked the attached file, it perfectly matches my skills. I am interested in working with you on this project. Read More

$30 USD in 1 day
(6 Reviews)
2.9
firoz7280

Hi there I can separate the data from single column to rows and column with minium time with lowest price if you award me this project. I'm an expert in this project. I am really interested in your project. I am availa More

$30 USD in 1 day
(1 Review)
2.2
sharminsultana35

Hello sir, I have read your project description carefully. I am ready to work on the project provided by you. If you give me proper guidelines I will surely be able to do your work beautifully and properly. I will comp More

$50 USD in 2 days
(2 Reviews)
1.2