Ahmed Hashish
New Member
- Joined
- Oct 15, 2023
- Messages
- 7
- Office Version
- 2019
- Platform
- Windows
Hello,
I am getting data from an excel workbook within a folder
Sheet has 3-4 rows at the top with couple of titles and blank rows,
Then there is a table below these few rows.
I am cleaning these few rows by removing them and then promoting headers from the table below.
The issue is that some data(columns) are not extracted into the power query editor,
And some columns (not all) in the table show null data.
I tried to remove some title (merged cells) above the table before running the query, and this works perfectly
and the data previously shown as null are now visible.
How do I overcome this within power query editor, without manually interfering with the source file?
As there are other users that are going to use this file and I am trying to make it user-friendly and automated as possible.
Thanks!
I am getting data from an excel workbook within a folder
Sheet has 3-4 rows at the top with couple of titles and blank rows,
Then there is a table below these few rows.
I am cleaning these few rows by removing them and then promoting headers from the table below.
The issue is that some data(columns) are not extracted into the power query editor,
And some columns (not all) in the table show null data.
I tried to remove some title (merged cells) above the table before running the query, and this works perfectly
and the data previously shown as null are now visible.
How do I overcome this within power query editor, without manually interfering with the source file?
As there are other users that are going to use this file and I am trying to make it user-friendly and automated as possible.
Thanks!
