Best Way to Transform Data into Desired Format
Quite frequently I have to transform data into the the format found in tab ''Original'' to the format in tab ''Desired''.
I was wondering what the quickest and most efficient way to do this would be: Pivot Tables? Formulas? I would typically use lookup formulas to match the country name to the year, but that is time consuming since in order to do that I would have to set up and format the sheet beforehand.
Any suggestions are more than welcome! Thanks.
Try this macro
Please Login or Register to view this content.
Open up the VBA editor by hitting ALT F11
Insert a new module by hitting Insert - Module
Paste the macro into the empty sheet
Hit ALT F11 to get back to the worksheet.
Run the macro by going to tools-macro in Excel 2003 or the view ribbon in Excel 2007/2010.
Martin
@AnitPivotTable
Still with an pivot table.
See the attached file.
Notice my main language is not English.
I appreciate it, if you reply on my solution.
If you are satisfied with the solution, please mark the question solved.
You can add reputation by clicking on the star * add reputation.
And yet another:
Please Login or Register to view this content.
If I've helped you, please consider adding to my reputation - just click on the liitle star at the left.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~(Pride has no aftertaste.)
You can't do one thing. XLAdept
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~aka Orrin
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks