macro to merge the columns in to single row

[baluvasa]

hi all,

i needed a macro to the following requirement

i had a excel sheet with data as please find the below excel sheet for both input and output tabs


thanks in advance

regards
vasa hemanth saikumar.

[jraj1106]

Hi

Try this:

data.xlsm

[baluvasa]

hi,
thankx for the reply..its working ... i need another small favour as iam new to macro ... in want to append

record
{final_delim=end,record_delim='\n',delim="~",null_field=''}
{

in the beginning of output as default.. thAT IS my output should be like

record
{final_delim=end,record_delim='\n',delim="~",null_field=''}
{
name:nullablestring[max=30];
rollno:nullabledecimal[4,0]{default=NULL};
salary:nullabledecimal[5,0]{default=NULL};
data:nullablestring[max=30];
}

thanks for ur kindly help...


regards,
vasa hemanth saikumar