Remove unwanted rows of data using Power Query for Excel or Power BI

preview_player
Показать описание
#powerquery #powerbi #excel
There are often times when a dataset in Excel or Power BI includes rows of data that you do not need. Rows such as unwanted headers, totals, and subtotals. In this video you will learn how to use Power Query to removed unwanted rows of data from your data set in Excel or Power BI.

Find out more about our Learn and Earn Activities

Watch more Power BI videos

Watch more Excel Videos
  1. Paula's Web3 & Crypto
Рекомендации по теме
Power Query - 0:05:40

Power Query - Remove unwanted rows (From any position)

HOW TO DELETE 0:03:59

HOW TO DELETE BLANK ROWS WITHOUT LOSING DATA [THE RIGHT WAY]

Delete rows with 0:00:51

Delete rows with empty cells in #Excel

How to Delete 0:01:56

How to Delete Blank Rows in Excel

Automatically Remove Top 0:10:22

Automatically Remove Top Junk Rows & Combine Data from Multiple Excel Files

MS Excel: Deleting 0:01:37

MS Excel: Deleting complete blank rows without deleting blank cells in the filled row

Remove unwanted rows 0:04:47

Remove unwanted rows of data using Power Query for Excel or Power BI

How to delete 0:02:58

How to delete alternate rows in Excel

Delete Empty Rows 0:00:31

Delete Empty Rows at the bottom of your Google Sheet, the easy way

Delete All Blank 0:00:39

Delete All Blank Rows in Excel Entire Row @BrainUpp

How to delete 0:01:01

How to delete specific rows in a large data origin

Delete Empty Rows 0:00:26

Delete Empty Rows with these Excel Shortcuts #shorts

How to Delete 0:04:08

How to Delete Rows Or Columns Based On Criteria In Microsoft Excel

Remove all rows 0:01:09

Remove all rows having all null values in Query Table in Power Query in Power BI

How to delete 0:02:15

How to delete infinite rows in Excel

How to Remove 0:05:33

How to Remove Blank Rows in Excel | 3 Methods to Delete Empty Cells

How to Filter 0:04:44

How to Filter and Delete Specific Rows in Power BI| #34

Delete Blank Rows 0:01:03

Delete Blank Rows between Data

Excel Tips - 0:01:46

Excel Tips - Hide or Remove All Unused Rows and Columns in Excel

How to DELETE 0:01:51

How to DELETE MULTIPLE ROWS All at Once in EXCEL

How to delete 0:02:40

How to delete rows with specific text in Excel

Power Query - 0:01:16

Power Query - Remove blank rows and columns from your data

3 Easy Ways 0:12:13

3 Easy Ways to Delete Blank Rows in Excel ✅

How to quickly 0:00:41

How to quickly hide unused cells, rows, and columns in Excel

Комментарии
Автор

Hi Paula.. thanks for this quickie Power Query tip.. very useful. Thumbs up for The Excel Club!

wayneedmondson
Автор

You saved a lot of time with your PQ video. Thank you ⭐️⭐️⭐️⭐️⭐️

marciolifecycle
Автор

I have the same question that has been made by Crissy Cluff. I need to access a huge table, but I don't want to extract all the data stored there. I would like something working like a "prefilter" acting as if I was writting a SQL select line. I thank and congratulate you for your channel. Very useful. Best regards, Thiago.

thiagotessarolosouza
Автор

I have data from a lengthy form. There are 855 columns, but not all are populated. I would like to import this into Access, but it's too large at over 255 fields. How can I import either into access or another excel file while excluding null fields or columns with blank cells? Any guidance is greatly appreciated.

HighHopesHizzy
Автор

Hi Paula, thanks for the video! If I have lets say 400 rows, but I want to remove rows 2-13 inclusive, how can I do that? Its simple to see how to remove top or bottom etc, but not a selection of rows

abailes
Автор

I have 50 rows and want to delete 30th row..How to delete?

robbysandhu
Автор

Hi you have skipped the concept of Remove alternative rows where it is important you disappointed

vamsisai