LinkBack URL
About LinkBacks
Hi Fellow Members
I have attached a file with for your kind help.
I want to query the 3 worksheet (schneider electric, Tech Onshore and Plantwerkz) to the worksheet "Query".
How to do it, as the 3 worksheets are not in table formart.
Rdgs
Kenny
Hi Fellow Members
I have attached a file with for your kind help.
I want to query the 3 worksheet (schneider electric, Tech Onshore and Plantwerkz) to the worksheet "Query".
How to do it, as the 3 worksheets are not in table formart.
Rdgs
Kenny
Last edited by Kenny Yip; 04-26-2024 at 02:21 AM. Reason: Solved & Thank You
Your file is locked and will not allow access. Additionally, you have not explained fully your requirements in the body of the thread. Please explain in detail what you want. Then upload a file that can be accessed without passwords to your Share Point. Remove the files from Sharepoint to your desktop and then upload them to this forum.
Additionally, your file has locked my access to Excel. It is frozen and you now require me to reboot and my machine. This does not make me happy and I am reluctant to offer any help.
Last edited by alansidman; 04-23-2024 at 09:47 AM.
Alan עַם יִשְׂרָאֵל חַי
Change an Ugly Report with Power Query
Database Normalization
Complete Guide to Power Query
Man's Mind Stretched to New Dimensions Never Returns to Its Original Form
@alansidman
Sorry about that. I overlooked it. My bad
Basically, i need to use power query to load and combine the three worksheet (Schneider, Tech and Plantwekz) to worksheet-Query
With Power Query
Please Login or Register to view this content.
@alansidman
Thanks for assisting me.
Now i have an issue is, presume if users have blanks within the table, then the query will also show the blank rows.
How to prevent this happening?
I have attached the example excel here.
WS-Schneider is the ws giving issue, hence query has blank rows.
If there are blank rows in the combined, then within PQ, remove the blank rows.
Please Login or Register to view this content.
@alansidman
Thanks mate, solve my headache.
Cheers
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks