# Data in row transpose

1. ## Data in row transpose

Hello Expert,

I have text data in row, I want to combine in one cell, I can use Transpose function but there is issue I don't want 0 will add in combine data, please check the screenshot you will better understand what I'm looking.

2. ## Re: Data in row transpose

any expert here for help.

Pete

4. ## Re: Data in row transpose

ok, sorry for that.

5. ## Re: Data in row transpose

You can put this formula in B2:

=IF(OR(A2=0,A2=""),"",A2&" ")&IF(OR(A3=0,A3=""),"",A3&" ")&IF(OR(A4=0,A4=""),"",A4&" ")&IF(OR(A5=0,A5=""),"",A5&" ")&IF(OR(A6=0,A6=""),"",A6&" ")&IF(OR(A7=0,A7=""),"",A7&" ")&IF(OR(A8=0,A8=""),"",A8&" ")&IF(OR(A9=0,A9=""),"",A9&" ")

It will be easier to follow if I show it like this:

=IF(OR(A2=0,A2=""),"",A2&" ")
&IF(OR(A3=0,A3=""),"",A3&" ")
&IF(OR(A4=0,A4=""),"",A4&" ")
&IF(OR(A5=0,A5=""),"",A5&" ")
&IF(OR(A6=0,A6=""),"",A6&" ")
&IF(OR(A7=0,A7=""),"",A7&" ")
&IF(OR(A8=0,A8=""),"",A8&" ")
&IF(OR(A9=0,A9=""),"",A9&" ")

Just add more terms at the end if you have data below cell A9.

Hope this helps.

Pete

There are currently 1 users browsing this thread. (0 members and 1 guests)