How to compile cells/columns in excel

[Ranjit Rane]

How to compile cells/ columns in excel

Column 01 Column 2
133456 123456
457993 123478
625992 245799

 

[herofox]

From the beginning ..... it must be apload excel file ,Since it is not possible to work on guesswork
but you can use this

=CONCATENATE(A2,B2)

 

[Ranjit Rane]

Thanks for the reply..however I wanted to compile data in different rows ..to a column...will be sharing the file

 

[p45cal]

1. Attach a workbook with before and after situations.
2. What do you mean by 'compile'?

 

[Ranjit Rane]

I meant to put the data of different columns..in a single column..one below the other.

 

[p45cal]

It really is a matter of supplying a workbook with what you want - saves us guessing (wrongly). If you can't be bothered, why should we?
Like this:
133456
457993
625992
123456
123478
245799

or like this:
133456
123456
457993
123478
625992
245799

?

 

[bosco_yip]

I meant to put the data of different columns..in a single column..one below the other.

Maybe,

In D2, array formula copied down :

=TRIM(MID(SUBSTITUTE(" "&TEXTJOIN(" ",1,TRANSPOSE(A$2:B$5))," ",REPT(" ",99)),ROW(A1)*99,99))

Edit :

If you don't have Textjoin function, try to use this longer formula instead.

=IFERROR(IF(ROW(A1)<=COUNT(A$2:A$5),INDEX(A$2:A$5,ROW(A1)),INDEX(B$2:B$5,ROW(A1)-COUNT(A$2:A$5))),"")