Nested =IF(ISBlank)

[c45ruler]

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.

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

 

[AhoyNC]

Try

Excel Workbook
	G	H	I	J	K	L	M	N
1	Help Gurus		Help Gurus
Sheet