Copy data from different columns into one column

[amartino44]

Hello. If I just one number in each each (row 1-100) for example, but in different columns, is there a way I can copy all of these numbers so that they are all in the same column--that is, they would stay in the same row but now they would also be in the same column. Obrigado.

[bryan0]

Hello. If I just one number in each each (row 1-100) for example, but in different columns, is there a way I can copy all of these numbers so that they are all in the same column--that is, they would stay in the same row but now they would also be in the same column. Obrigado.

How many columns are they in? If it's just A and B, put this formula in C1 and drag it down. It will take what's in column B, unless there's nothing there, in which case it'll take the value in column A:

Please Login or Register  to view this content.

[amartino44]

Hmm. Nice. But they are in 15 different columns lol