Forum Discussion

Copper Contributor

Nov 08, 2023

How to combine column?

Hi everyone, having in a a series of values in a cell, and in b other values (the number of cells with values can be variable), there is a way to have in C a list with all the possible combinations ...

excel

HansVogelaar

MVP

Nov 08, 2023

Tancredi

For example

=TOCOL(OFFSET(A1,0,0,COUNTA(A:A))&" "&TRANSPOSE(OFFSET(B1,0,0,COUNTA(B:B))))

Tancredi

Copper Contributor

Nov 08, 2023

HansVogelaar

hello and thanks for the answer: but do you know that the formula doesn't work on my computer? Maybe I need to activate it somehow, or translate it? An old Excel 2007 in Italian version is installed. Thank you