You can define cr/lf delimiter for getting data in rows. As far as columns are concerned, you can use substring function of sql to create and fill columns. eg: if you need to spilt 'goodluck' into 2 columns - good|luck

col1 = substring(columnName,starting position,length)

col1=substring(ColumnName,1,4).....will give 'good' from column columnName which can be filled into new created column..