Hi guys;
I have 2 columns like this
A1 B1
XXXXX XXXX
XXXXX
XXXXX
XXXX
XXXXX
XXXXX
XXXXX
XXXXX
XXXXX
XXXXX
XXXXX XXXX
I need to combine all rows in $A if $B+1 is empty
Thanks in advance
Hi guys;
I have 2 columns like this
A1 B1
XXXXX XXXX
XXXXX
XXXXX
XXXX
XXXXX
XXXXX
XXXXX
XXXXX
XXXXX
XXXXX
XXXXX XXXX
I need to combine all rows in $A if $B+1 is empty
Thanks in advance
I don't understand. Do you mean like this?
A B C D 1 A1 B1 Combined 2 XXXXX XXXX XXXXX 3 XXXXX XXXXX 4 XXXXX XXXX 5 XXXX XXXXX 6 XXXXX XXXXX 7 XXXXX XXXXX 8 XXXXX XXXXX 9 XXXXX XXXXX 10 XXXXX XXXXX 11 XXXXX 12 XXXXX XXXX
Dave
A1 = 1111 B1 = 2222
A2 = 2323 B2 = blank
then B3= A1&" "&A2
and so on
if B2 = blank then B3 = A2
and so on from all A$ & B$
sorry attachment is not available on my browser i dont know why
Last edited by mouaffaq; 10-04-2016 at 10:47 AM.
there might be more than 3 cell to combine
please check the photo in the below link
http://adanwater.com/test.jpg
please check the photo in the below link
http://adanwater.com/test.jpg
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks