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.


[TABLE="width: 520"]
<!--StartFragment--> <colgroup><col width="65" span="8" style="width:65pt"> </colgroup><tbody>[TR]
[TD="width: 65"]G[/TD]
[TD="width: 65"]H[/TD]
[TD="width: 65"]I[/TD]
[TD="width: 65"]J[/TD]
[TD="width: 65"]K[/TD]
[TD="width: 65"]L[/TD]
[TD="width: 65"]M[/TD]
[TD="width: 65"]N[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD]Help Gurus[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
<!--EndFragment--></tbody>[/TABLE]


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