Removing empty cells in a table row

[Xtreme-90]

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

[danextian]

Hi @Xtreme-90,
Is that supposed to be a Power BI visual or your data source? It doesn't look like the native table or matrix visuals or any other custom table visual I am aware of.

[SamInogic]

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 crm@inogic.com

Service:  http://www.inogic.com/services/ 

Power Platform/Dynamics 365 CRM Tips and Tricks:  http://www.inogic.com/blog/

[SamInogic]

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 crm@inogic.com

Service:  http://www.inogic.com/services/ 

Power Platform/Dynamics 365 CRM Tips and Tricks:  http://www.inogic.com/blog/

[Xtreme-90]

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