Normally it would be a problem but one spreadsheet has 2 thousand rows of data where product information is spread over 2 rows...

eg. I've simplified it...

row 1 = product code, description
row 2 = product price

row 3 = product code, description
row 4 = product price

and so on...

what's the best way to convert this into a database ? Ideally I need a method to combine every 2 rows into a single row in the database

 

Macro in Excel to move the data onto a single row for each entry?

Then it's just a straightforward import into the database.

 

ooh macros - never used em.

thanks for the advice, will check it out

 

how do you enter this formula in Excel ?

if J6 starts with "L" then I7=J6

so far using the formula wizard I've got

=IF(I6="L*",J5=I6,"-")

but the ="L*" is clearly wrong

 

=IF((LEFT(I6,1))="L",I6,"-")

 

perfick! it's like VBasic sorta!