Condense Data List

[radley1]

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:

 

[Fluff]

How about like

=CHOOSECOLS(FILTER(Sheet1!A2:G1000,Sheet1!G2:G1000<>""),1,-1)

 

[radley1]

Thats perfect thank you!
How would the formula change if I wanted to include information in Column H as well that I have now added?

So i would end up with a list like this:

 

[radley1]

Thats perfect thank you!
How would the formula change if I wanted to include information in Column H as well that I have now added?

So i would end up with a list like this:
View attachment 107949

 

[radley1]

To confirm, this is the starting data:
(columns have shifted slightly since i started)

So I still need the formula to question if Column F has a value, and then pull into a condesned list Column B, F & I together. Would I need column I to be to the left of column F for it to work?

 

[Fluff]

How about

=CHOOSECOLS(FILTER(Sheet1!B2:I1000,Sheet1!F2:F1000<>""),1,5,8)