Hello, I have a pivotal database (Accounts in rows 1-20, Entites in columns C-I, values are from C2-I20). I am easily able to transform pivotal view to rows using the function TOCOL. But in my database there is a lot of cells (various combination of Account & Entity), that include 0 values. I am looking for a solution how to use a formula TOCOL using maybe another formula FILTER to list only non-zero values. The function FILTER does not work in more than 1 column. I am providing an example in attachment. Any idea please?
Bookmarks