convert one column into many columns
Hi,
The delimiter is at every 9th record..so Excel is converting the 9th, 18th,
27th...cell into next column.
Any more ideas?
thanks.
"JE McGimpsey" wrote:
One way:
Choose Data/Text to Columns/Delimited
In article ,
Ajay wrote:
Hi,
I have a column which contains data that shd go into 9columns.
can anybody tell me how to convert this single column into 9 columns? I have
a delimiter at every 9th record.
thanks,
Ajay
|