I am trying to pull data from multiple columns from a survey via google forms some of which are blank and some of which have a text. There is only one cell with text for each row in columns H-N. In rows H-N there is one cell with text per row. I'd like to be able to pull each of the text's into row G rather then individually grab each value and place it in column G. I've tried using IF(H45="",IF(I45="",IF(J45="",IF(K45="","")))) but I'm not sure how to pull the value from the cell if it's not blank.
<!--StartFragment--> <colgroup><col width="65" span="8" style="width:65pt"> </colgroup><tbody>
<!--EndFragment--></tbody>
How to I make it so so "help gurus" is displayed in row G? Thanks
G | H | I | J | K | L | M | N |
Help Gurus |
<!--StartFragment--> <colgroup><col width="65" span="8" style="width:65pt"> </colgroup><tbody>
<!--EndFragment--></tbody>
How to I make it so so "help gurus" is displayed in row G? Thanks