Spreadsheet headache!

[Wraith]

I'm no office geek by any stretch, but this is doing my nut in!

I have 2 spreadsheets in openoffice containing 3 columns and 6058 rows (don't ask)

They are both identical-ish, they have random blank fields in them, now all I'm trying to do is merge them together without duplicate entries but also filling in the blanks so that I have 1 complete document from 2 partial documents, if that's clear enough.. but my head is a shed and I'm 2 minutes from smashing the monitor..

Any help would be greatly appreciated..

 

[SPS]

When you say blanks do you mean, completely blank rows?
And also are you saying that there's rows that match in both documents?

 

[Wraith]

Here is what I have.. I want to merge these 2 together to create a complete document.

 

[SPS]

I'm still slightly confused.

Where there's missing authors or messages does that mean you want the record deleting?

I think in hindsight a database might have been a better choice :lol:

 

[maniac]

deleting the blank cells will make the data corrupt, authors and messages wont match anymore bud...

 

[SPS]

deleting the blank cells will make the data corrupt, authors and messages wont match anymore bud...

Oh ok, I get you. To be honest the easiest way to do this would be to export them as .csv files and write a python script to create a new .csv and reimport, in my opinion.

 

[maniac]

or do it manually and then forget to save

 

[SPS]

If you want me to do it for you just send the files over

 

[Wraith]

I'm good guys, thanks for the offer SPS but I got this.. Converted the spreads into databases. I'll finish off tomorrow.

 

[SPS]

I'm good guys, thanks for the offer SPS but I got this.. Converted the spreads into databases. I'll finish off tomorrow.

Ah ok no worries. It actually turned out that I already had a script that did this for a Uni task a while back :lol:

So if you cba it would take seconds ^_^

 

[SuB]

lol you could just import this into a db (as it sounds you did) and handle it from there I'm not sure i'd be writing a script for it when a simple import and sql statement would have done the trick. The fact you already had it written is pretty cool though lol

 

[Wraith]

Thanks again guys but I have cracked it perfect I'm rather impressed, but I have no idea how I managed it.

Oh well enjoy your weekends.