Merge multiple spreadsheets files into one

[crowermann]

Hi,
I’m trying to merge multiple spreadsheet files with the same heading into one master copy. All the files has the same heading with two columns and always different number of rows.

They look like this:

file1.odt

A:Name B:Address

1. John Padbury street
2. Steve Rosemary street
3. Kate High street

file2.odt:

A:Name B:Address

1. Henry East street
2. Mary Rose street

file3.odt
Name Address

1. Stuart Scotland Avenue
2. Hermione Backyard Square
3. Emma London street
4. Gary Stanford street

I would like to combine these .odt files into on file. Something like this:

Name Address

1. Hermione Backyard Square
2. John Padbury street
3. Steve Rosemary street
4. Kate High street
5. Henry East street
6. Mary Rose street
7. Emma London street
8. Gary Stanford street
9. Stuart Scotland Avenue

I’ve found the way to accomplish it with macros on MS Excel but I’m running Ubuntu with Libre office and can’t get it to work.
Is there any way to have this done?

Thanks!

Rob

[Lupp]

1. How do you keep track of “that many” documents? A reasonable solution must regard this. Is there a bookkeeping sheet (range) in the merger document?

2. As you had already merged but look again for a solution you may want a DYNAMIC solution. Is this the case?

3. Your example does neither keep the order of the sources nor that of items? Is there a secret sense in it?

4. Might the sources first be (once for all) be assembled one sheet for every source in ONE document?

[horst]

Have tried a simple copy and paste from one file to the other? It worked in my case very good.

[crowermann]

I do copy and paste it manually but it’s really slow. I work with dozens of files sometimes which is a painstaking process.

[Lupp]

Did you consider answering my questions?