Hi. I want to combine three different cells in a cell with additional empty columns..
funct1 =
'Q7' 'Q12F' 'Q12G' 'Q12H' 'Q12I' 'Q12L' 'Q12M'
funct2 =
'Q12G' 'Q12H' 'Q12I' 'Q12L' 'Q12M'
funct3 =
'Q12G' 'Q12H' 'Q12I'
Final cell will become like this.
funct =
'Q7' [] 'Q12G' [] 'Q12G' [] 'Q12F' [] 'Q12H' [] 'Q12H' [] 'Q12G' [] 'Q12I' [] 'Q12I' [] 'Q12H' [] 'Q12L' [] [] [] 'Q12I' [] 'Q12M' [] [] [] 'Q12L' [] [] [] [] [] 'Q12M' [] [] [] [] []
Could anyone show me how?
Best Answer