Filter data from table from two rows
I have a table visualization and there are companies listed and the first row shows 0 under some columns. So, I want to filter out that row the rows and column that have 0s. Then I want to go to the last column which is blank for the most part, but when it show the value, I want to pull that data in that column and also show some other columns associated with it. This two sets of rows should merge as one row in the end. The screen shot is shown I hope this is enough information. Thank you!
