Remove blank cell of rows and shift the rest to left

[mehrana]

I have a table with 60+ columns. More data is periodically added (using Microsoft form) to this table. There are / will be many blank cells in each row (80% of the entire cells). Instead of this very wide table, I need to display only the data on a screen without the blank cells. The screen can of any kind, such as another table with the blank cells removed and data cells are shifted to left. It will be great if this can done automatically each time when a new row is added or more data is added to cells (on left side of the existing).

I appreciate any help you can provide.

 

[felixstraube]

you could use conditional formatting. and format differently by odd /even row number.

What do you want to show instead of true/false? Or do you want just to eliminate it?

 

[mehrana]

you could use conditional formatting. and format differently by odd /even row number.

What do you want to show instead of true/false? Or do you want just to eliminate it?

I want to show a check-box in that column/cell (the same as the main sheet/table), that user can click and change the status between True and False (not showing the words). Then I can apply conditional formatting based on the condition, like change color of the row.