Transpose Data in Excel and Properly Normalize it in Microsoft 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.

Silver Members and up get access to an Extended Cut of this video. 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.

MEMBERS VIDEO:

BECOME A MEMBER:

LEARN MORE:

PRE-REQUISITES:

LINKS:

RECOMMENDED COURSE:

FREE TEMPLATE DOWNLOADS:

ADDITIONAL RESOURCES:

KEYWORDS:
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

QUESTIONS:
Please feel free to post your questions or comments below. Thanks.

[cominisful]

Your videos are amazingly simple! I have turned my weekly reports into a few quick clicks and I can't thank you enough!

[ephremhassengossoma]

highly appreciated your neatly presented and fast style of teaching. bless you!!

[moizrashid]

Thank you! I am indebted to your helpful videos!

[learningfromYT]

Left align is the way! Thanks for another great lesson.

[andrewcabasan]

Hi! your videos are very educational. How to count the number of Yes and No where these are the values under more than 20 different field names? Hope you can help. Thanks.

[stuartround]

Great video again, but wouldn't you want the total to be the total budget for the year, rather than a cumulative total of the category over several years?