Hi All
I am looking at creating a forumla that essentially looks up to a list in a sheet and says IF this cell is not blank then take this & this cell.
EG
Below screenshot shows how the list of data is given.
Column G is doing a sum to pull a value from a lookup.
I want to have a second sheet that condenses this data to remove the blanks so the information can be saved as a CSV and imported.
So I need a formula to say if column A & G are not blank then add to a list, ideally to look like this:
I am looking at creating a forumla that essentially looks up to a list in a sheet and says IF this cell is not blank then take this & this cell.
EG
Below screenshot shows how the list of data is given.
Column G is doing a sum to pull a value from a lookup.
I want to have a second sheet that condenses this data to remove the blanks so the information can be saved as a CSV and imported.
So I need a formula to say if column A & G are not blank then add to a list, ideally to look like this: