need help :How find a specific string in the all the column of excel and return that clmn

[sahasanb]

PFB the attached excel.

I want to return F4 as its contain Units. If "units" in Column F2 then Column F2 will return.

That means "Units" position is not specific.

[IraWatt]

Hey @sahasanb,

Here is one way to do this:

The transpose lets you search all the columns at once for the word "Units" Then once found I convert it all back using the cross tab tool. 

Any questions or issues please ask :)
HTH!
Ira