Kamis, 15 Maret 2012

Re: [MS_AccessPros] Excel, off topic, transpose and insert commas

 

Hello all,
 
I have a column of Excel data that is all numbers, about 15,000 or so, one number in each cell at present.
 
However, I want to turn that column into a row, where all the data can be seen from a single cell in that row.
 
Example, I want to turn this:
 98164754
15642829
15636430
15699463
15600864
15652140
 
Into this, no spaces, but a comma between each number:
 
98164754,15642829,15636430,15699463,15600864,15652140
 
Exactly how do I do this?  Because, I know one simply fact, I am NOT doing this manually.
 
Eric

[Non-text portions of this message have been removed]

__._,_.___
Recent Activity:
.

__,_._,___

Tidak ada komentar:

Posting Komentar