Data Engineering TSC 03 Data Transform Delete Columns

Опубликовано: 06 Август 2026
на канале: Data Engineering

Using Excel Power Query to Remove Columns

In this video, I walk you through the process of transforming data in Excel, specifically focusing on removing unnecessary columns. We started with a dataset that had 81 columns, and I demonstrated how to delete specific columns step by step, ensuring we keep track of the changes made. I also highlighted that when multiple columns are removed, they aggregate into a single step in the query editor, which can be renamed for clarity. My goal is to streamline our dataset to only include the relevant information, so please follow along and replicate these steps in your own files.

00:00 Introduction to Data Transformation
03:06 Reviewing Applied Steps
08:01 Finalizing Data Transformation