Home » Forums » Open Source Learning Center » Question and Answer

Convert Column to text

Submitted by eenovice on 14 August, 2013 - 04:16

I have a column of 200 mobile numbers.

I need to convert these into row of text in set of 4 mobile numbers

eg

12345678, 12345678, 12345678, 12345678

12345678, 12345678, 12345678, 12345678

12345678, 12345678, 12345678, 12345678

Plse give your expert advise.

Thanks

‹ Excel Solver not solving extract data from various excel files on common field using vba ›
»

-Select cell/s in which these

Submitted by niluhom on 15 October, 2013 - 10:52.

-Select cell/s in which these data is stored
-Selection Text to Column from Data menu
-Convert this data in to column
-Then apply transpose steps as mentioned in above.

»
Almir's picture

Use Paste Special*>Transpose

Submitted by Almir on 7 October, 2013 - 15:05.

Select first 50 numbers, copy them and Paste Special => Transpose.
Repeat this for the next 3 groups of 50 numbers.

»