We have two Excel workbooks each with multiple worksheets. The data is not normalized, but needs to be. I have uploaded a workbook example with two worksheets. The actual data includes two workbooks with a grand total of 21 worksheets.
We need all the data in the worksheets converted to this format: Group | Category | Class | Subclass | Month | Year | Units | Day Utilization | Dollar Utilization.
So, for Scissor worksheet, the first record in the new Excel worksheet will be:
Scissor, RT, 26SCISSOR, DF, January, 2014, 21, 70.66, 63.66
Please contact me if you need any clarification.
Thank you for the consideration.
27 freelanceria on tarjonnut keskimäärin 141$ tähän työhön
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. Willing to take up your project. Thank you, Regards.
Hai, I am hardworking and would complete the given projects on time despite the circumstances and selecting me would be worth the cost of the project.
I do not need any amout from you. If you happy with my work then you can give me payment whatever you want. Please just needed an opportunity. Thanks Devendra Paliwal [login to view URL] at [login to view URL]
Hi, I am an experienced .NET developer with great skills you mentioned in your description. I can do this by using VBA for Excel. Great communication skill is provided as well. Thanks.