Drag Across aint working

[panyagak]

Hi fellow Mrexcel enthusiasts.

am using WPS on smartphone pls.

i have a table that my smartphone cant attach.

am trying to pick $B$6 and concatenate with B12, C12, D12....to Z12

Then pick $C$6, concatenate with B12, C12, D12....to Z12.

all the way until $Z$6 joining up with B12, C12, D12....to Z12.

Starting at Cell B14

regards n thanks
Patrick
Nairobi Kenya

 

[panyagak]

Your title says drag across, now you are dragging down, which do you actually want?

Either as long they result in same answer

 

[MARK858]

Either as long they result in same answer

A bit puzzled, are you saying now that you don't have a solution?

 

[panyagak]

A bit puzzled, are you saying now that you don't have a solution?

No no......I already thanked you a long time AGO & actually implemented your solution!!!! IT IS PERFECT!!

 

[Peter_SSs]

@panyagak
Please update your Account details (click your user name at the top right of the forum) so helpers always know what Excel version(s) & platform(s) you are using as the best solution often varies by version. (Don’t forget to scroll down & ‘Save’)