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
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.
36 freelancers are bidding on average $124 for this job
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
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
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
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.