Completed

I need an excel expert

I have a big excel table from a supplier and I need to seperate all the data in to some sort of Pivot Table I would say, But my only issue is that in a lot of the cells there are majority variations of part numbers that need to be also put onto each line.

I have uploaded a short file of what I am talking about.

Sheet 1 Will have a small version of the table I have and Sheet2 has an example of how I need it layed out

Skills: Excel, Data Processing, Data Entry, Visual Basic

See more: need excel expert, need excel expert match columns, need excel expert create macro, i need an expert in english language that would help to grade my essay test, i need an expert in formatting word documents in australia, i need an expert on whmcs to make a very simple job, i need an expert, i need excel data entry, i need excel expert, i need seo expert for my, i need seo expert, urgent i need an expert on grasshopper, www i need an expert to write my speech com, where can i hire excel expert, any company need excel expert from home, how do i find excel expert in sri lanka, i need an expert in facebook, i need an expert modeler, i need an expert to build a website, i need an expert to fix my wordpress website quotes

About the Employer:
( 1 review ) Helensvale, Australia

Project ID: #22384725

Awarded to:

umairabdillah12

Hi There, I can help you to seperate all the data in to some sort of Pivot Table as like you say, i have many experience using excel over 10 years, please kindly chat me,' thanks. Regards.

$50 AUD in 2 days
(15 Reviews)
4.6

36 freelancers are bidding on average $124 for this job

jaylancer43

Hello Sir, I am a full time freelancer and can work dedicated on this till completion. My name is Jay and I'm an Expert Excel and VBA programmer on freelancer.com and have been featured by the freelancer community (g More

$200 AUD in 2 days
(750 Reviews)
8.5
schoudhary1553

Hello Sir, I am expert who understands the value of time. I pride myself in my attention to detail. I am very hard working and aim to deliver in less time than quoted. I want to make you, my employer happy without cha More

$220 AUD in 4 days
(353 Reviews)
8.0
P0L

Hello, I’m an Excel expert and I would like to help you with your project. Please check my profile and contact me to discuss further details. Regards.

$100 AUD in 1 day
(338 Reviews)
7.4
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 application that will transform your data from one format (sheet1) to an More

$100 AUD in 2 days
(240 Reviews)
7.5
elqueabandona

Hello, my name is Cristian, i am Excel/VBA expert. I am in the top 5 of freelancers in this area and i have more than 240 projects successfully completed here. Look at the comments that employers have left me, that i More

$100 AUD in 2 days
(241 Reviews)
6.9
dgled

I develop inventory modules in Microsoft Excel by VBA. I built modules which enable you to manage inventory transactions in a spreadsheet by Bill Of Materials, cost centers, currencies and to get immediate reports and More

$250 AUD in 7 days
(88 Reviews)
7.1
TonmoyRoy111

Dear client I am an excel expert and I have previously carried out a number of projects in excel in the past using macros and formulas. I can definitely help you in this project. Kindly contact me. Roy

$100 AUD in 1 day
(354 Reviews)
6.9
periyannas

Hi, Nice to know your requirement. I am an excel vba, vb6 professional and have delivered over hundred excel vba projects in the last one year. Making the SKU column values are tricky it seems, as there are repetitio More

$140 AUD in 3 days
(112 Reviews)
6.3
wsh2

Respectfully, you really need a database (such as MsACCESS) to do this right. You would then use MsEXCEL to analyze and present the database in an easily accessible workbook. Greetings from the USA.. {smile} Highly e More

$395 AUD in 7 days
(53 Reviews)
6.4
aimefx

Hi, I am an expert in Excel, I have checked the attached file and I can complete your project in 1 day using Excel Power Query. I am ready to start your project immediately, please send me a message to discuss further. More

$50 AUD in 3 days
(81 Reviews)
6.0
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

$180 AUD in 2 days
(132 Reviews)
6.0
vsprybhanu

Hi, My name is Virendra. I am experienced Data Analyst and Macro Developer. I have read your instructions carefully and checked attached file. I can develop a macro to get data from sheet1 and arrange them same as More

$45 AUD in 1 day
(95 Reviews)
5.7
afenache

Hi, I have checked the excel sample that you attached to the project post and I can assist you to create the payhs for each part. Best regards, Florin Enache

$100 AUD in 1 day
(22 Reviews)
5.3
paulodayto08

Hi Good Day! A serious freelancer here. I can help you to complete this project. I saw your file but need additional detail from you. Can you message so we can discuss it. I can make it automated using Excel Formulas More

$100 AUD in 2 days
(36 Reviews)
4.5
IgeS

Hi there, I saw that there are stacked data in your records and needed to be separated, each having a single row. Please tell me more about your data - how many rows of data do you have . we need to determine our be More

$80 AUD in 2 days
(9 Reviews)
4.3
Nouyana

Hello! I offer you a macro that will create you a pivot table in one click. The macro can be launched using both hot keys and buttons on the ribbon. I will also provide you with any help on its use. If necessary, I wil More

$50 AUD in 2 days
(1 Review)
2.6
(2 Reviews)
2.2
digitalmarkett

Hi hope you are doing well. I can make pivot tables as per your need. please explain what is majority options of numbers means? let me hear from you. thanks

$55 AUD in 1 day
(1 Review)
1.1
shagun1208

With a good efficiency, I can complete this task in a needed time. I have some skills required to complete this task and otherwise I'm a hardworking person to complete this project.

$111 AUD in 2 days
(0 Reviews)
0.0
AslamGilani

Hi... looking forward to your kind orders. I am quite confident that you will like my work and polite coordination. thank you

$77 AUD in 2 days
(0 Reviews)
0.0