Forum Discussion

Copper Contributor

Jul 10, 2018

fill in the missing cells

Hello, is there a way to auto convert from Table1 to Table2 below? Table1 contain a sheet created for a tree map but I need to fill in the missing cells to produce the following CSV text format: ...

excel

Formulas and Functions

Hassan null

Copper Contributor

Jul 12, 2018

Thanks Jan but it does not seem to work? I keep getting zeros "0" in the empty cells.

JKPieterse

Silver Contributor

Jul 12, 2018

Did you press the up arrow key immediately after pressing the equal sign, but before pressing control+enter?

Hassan null
Copper Contributor
Jul 12, 2018
Yes I did but still not working.
When I changed the cells format from General to Text, I get =B1 inside the empty cells.
- JKPieterse
  Silver Contributor
  Jul 12, 2018
  You should not change the cell format to text!
  Also, make sure the active cell is NOT on row 1 (you can press the tab key until you have a cell on a different row).
  - Hassan null
    Copper Contributor
    Jul 16, 2018
    I'm sorry Jan this still does not work for me! Perhaps we have different versions of Excel or it cold be an environment configuration differences? I have MS 365 Pro Version 1708.
    
    Can you please post the example table you were able to generate with these steps?
    Thanks