Transpose Tool - Nifty Access

This “Transpose Tool” allows you to easily convert Spreadsheet structured data into MS Access structured data. This transformation of your data allows you to build incredibly powerful MS Access Databases. This transformation is a critical process, only known to and practice by "Power Users", users with a good grasp of MS Access, usually the "Go To" person in your organisation for MS Access problems. If that's you, then you probably already know of this technique. For more information see my blog here:-  Excel in Access , where I explain why you should perform this “Transform” of your data. I give examples in text; images and video.  See instructions on using the  "Normalization Tool”