Urgent help It this possible???

[Eric Lovelace]

I have a spreadsheet with row 1 as my header allof the other rows i need
exported to a file in the format below. This is critical and any help is
greatly appreciated

This is my spreadsheet layout. But there could be up to 8000 rows:
c_last_name c_first_name c_middle_name c_userid
Ables Donna F donna.ables
Lovelace Eric
eric.lovelace

I need to export this to a file in this format. Each row needs to be
enclosed in ( ) and each field in that row needs to be in " " with a comma
seperating each field.
( "ables" ,"donna" , "f" ,"donna.ables" )
( "lovelace" ,"eric" , "" ,"eric.lovelace" )


Thanks a million

 

[Michael]

Eric, assuming your data table is in columns A,B,C and D, put the following
in cells:
E2 "
F2 ("
G2 ",
H2 ")
I2 .
Next use the Concatenate function starting in J2:
J2 =concatenate(f2,a2,g2)
K2 =concatenate(e2,b2,g2)
L2 =concatenate(e2,c2,g2)
M2 =concatenate(e2,a2,i2,b2,h2)
Next, copy E2 thru M2 down 8,000 rows. It's not elegant, but it should work.