Home > other >  Google Spreadsheet - Is there a way to overflow over blank cells
Google Spreadsheet - Is there a way to overflow over blank cells

Time:09-12

I wonder if someone could help me fixing this issue

snapshot of my work

Planning to have nearly 100 columns to be viewable without scrolling horizontally, so each column shoud have 21 pixels's width, so it's for this reason I can't nor enlarge the columns neither merge themm...

I need that text in A2 overflow/overwrite over E2, F3, G3, H3 cells which are blank since the validation data in E3 is not selected

I want that A2 reacts exactly as I2 is doing by overwrites blank cells in front of it (M2...)

Could you help me fix this out? Any advice would be appreciated.

I share with you an example of my work enter image description here


update:

={"";IFNA(VLOOKUP($E$5,Sheet2!$A$2:$E$5,5,FALSE))}

enter image description here

  • Related