Forum Discussion
Removing empty cells in a table row
Hi SamInogic,
Thanks for your help the last time
I have this visual that I am representing as a table. How can I remove the empty spaces in a cell without affecting the data in other rows of different columns? Some of these empty rows are between data. Thanks
4 Replies
Hi Xtreme-90 ,
Is it possible to attach an sample report or your table data structure?
Thanks!
Inogic Professional Service Division
An expert technical extension for your techno-functional business needs
Power Platform/Dynamics 365 CRM
Drop an email at [email protected]
Service: http://www.inogic.com/services/
Power Platform/Dynamics 365 CRM Tips and Tricks: http://www.inogic.com/blog/
Hi Xtreme-90 ,
If you have blank rows in table as shown in below screenshot, you can use Remove Blank Rows OOB option in power query editor.
Navigate to Power Query by clicking on “Edit Query” and choose Remove Rows>> Remove Blank Rows option as show in the below screenshot.This will remove the blank rows and your table will be look as below:
If this answer helps, please mark it as an Accepted Solution so it would help others to find the solution.
Thanks!Inogic Professional Service Division
An expert technical extension for your techno-functional business needs
Power Platform/Dynamics 365 CRM
Drop an email at [email protected]
Service: http://www.inogic.com/services/
Power Platform/Dynamics 365 CRM Tips and Tricks: http://www.inogic.com/blog/
Thanks for the reply. The issue is that rows are blank in each column but not blank in an adjacent column. See the example: the headings are (Cars, Bike and Horse). The data source does not have these spaces, but the table visual does. There is a space between Mike and Henry; Nat and Junior. Thanks for the help
Cars Bike Horse Mike Mike Ken Lisa Nat Dave Henry Sunny Love Junior Love
