hi, i want to change the data in sheet1 into sheet2 format. is there any easy way to do that without manually setting row and columns and filling data.
hi, i want to change the data in sheet1 into sheet2 format. is there any easy way to do that without manually setting row and columns and filling data.
Do you already have those column and row headings?
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
Try a Pivot Table.
By-the-way you have trailing spaces in the OCP numbers in Sheet1. I deleted those so you wouldn't get repeating numbers in the Pivot.
See attached.
Dave
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks