By Richard Rost 6 months ago
Transpose Data in Excel & Normalize it in Access
In this video, I'm going to show you how to transpose data in Microsoft Excel, import it into Microsoft Access, and then set it up in properly normalized, relational tables.
Aarav from Bengaluru, India (a Silver Member) asks: I get budget sheets from my head office where the category does down column A and the years go across row 1. What's the best way to get this data into an Access database? I get fields called 2020, 2021, 2022, etc. and I know this isn't the way it should be.
Members will learn how to add some extra functionality to our Budget form including filtering combo boxes, and a button to automatically add all of the categories from next year to our table.
Silver Members and up get access to view Extended Cut videos, when available. Gold Members can download the database template from class plus get access to the Code Vault. If you signed up on YouTube you have to register on my YouTube Find User page so I can set up your account here on my web site. If you're not a member, Join Today!
access 2016, access 2019, access 2021, access 365, microsoft access, ms access, ms access tutorial, #msaccess, #microsoftaccess, #help, #howto, #tutorial, #learn, #lesson, #training, #database, transpose data in an access table, Transposing Data in Microsoft Access Tables, Transpose a Table, How do you transpose data in Microsoft Access, ms access transform rows to columns, convert rows to columns in MS Access, Reorganizing Access tables, how to convert horizontal data to vertical data in access
Subscribe to Transpose Data
Get notifications when this page is updated
Check out these other pages that may be of interest to you: