Ask Your Question
0

Merge multiple spreadsheets files into one [closed]

asked 2014-08-07 18:52:21 +0100

crowermann gravatar image

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

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2016-03-01 21:30:28.793902

Comments

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?

Lupp gravatar imageLupp ( 2014-08-09 08:24:53 +0100 )edit

2 Answers

Sort by » oldest newest most voted
0

answered 2014-08-09 11:36:04 +0100

crowermann gravatar image

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

edit flag offensive delete link more

Comments

Did you consider answering my questions?

Lupp gravatar imageLupp ( 2014-08-09 20:57:42 +0100 )edit
0

answered 2014-08-09 03:16:51 +0100

horst gravatar image

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

edit flag offensive delete link more

Question Tools

1 follower

Stats

Asked: 2014-08-07 18:52:21 +0100

Seen: 7,350 times

Last updated: Aug 09 '14