Moving a row with info into one column

[Tom90]

Hi can anyone help, I have a table that 11 row by 11 columns and within the rows there will be one entry of text but not always is the same column what I am looking for to find a formula that will move through each row by column by column and find the one that has text in it and move it back to a single column "A" "Main Data", As per the file I am trying to move the data in column "A" "Main Data"

Tom90

 

[David Evans]

Hi can anyone help, I have a table that 11 row by 11 columns and within the rows there will be one entry of text but not always is the same column what I am looking for to find a formula that will move through each row by column by column and find the one that has text in it and move it back to a single column "A" "Main Data", As per the file I am trying to move the data in column "A" "Main Data"

Tom90

Will each row always only have one cell with data in it? If so just concatenate them all A1=Concatenate(b1,c1,d1,e1 ...)

 

[Hui]

Tom

I'd put this in Cell; A2:
=IFERROR(INDEX(B2:K2,,MATCH("ZZZZZZZZZZ",B2:K2,1)),"")
Copy down
Make sure there are more Z's than the longest piece of Name

see attached file:

 

[Somendra Misra]

Hi,

Another alternative:

in A2 and copy down.

=LOOKUP("zzzz",Sheet1!$B2:$K2)

Regards,

 

[Tom90]

Hi Guys, thanks for all your answers they all work well, Tom90