Forum Discussion
Consolidating multiple copies of the same document with minor differences
My team uses Box to share files. The problem is, if multiple people open the same file at the same file, Box will automatically "Save As" creating multiple copies of the same file, with minor differences. For example, we might end up with 3 spreadsheets that are as follows:
| Month | Product 1 sales | Product 2 sales | Product 3 sales |
| January | $300.00 | $450.00 | $800.00 |
| February | $350.00 | $500.00 | $700.00 |
| March | $250.00 | $525.00 | |
| April | $450.00 | $550.00 | |
| May | |||
| June | |||
| July | |||
| August |
| Month | Product 1 sales | Product 2 sales | Product 3 sales |
| January | $300.00 | $450.00 | $800.00 |
| February | $350.00 | $500.00 | $700.00 |
| March | $250.00 | $750.00 | |
| April | $450.00 | $700.00 | |
| May | |||
| June | |||
| July | |||
| August |
| Month | Product 1 sales | Product 2 sales | Product 3 sales |
| January | $300.00 | $450.00 | $800.00 |
| February | $500.00 | $700.00 | |
| March | $525.00 | $750.00 | |
| April | $450.00 | $550.00 | $700.00 |
| May | |||
| June | |||
| July | |||
| August |
As you can probably see, this isn't 3 sets of data, it's 3 versions of the same set of data, with each version missing some of the data. Is there a way to consolidate all this data into a single spreadsheet, without just copying and pasting the data manually? I tried using the "Get & Transform Data" function, but it seems to be designed for combining separate sets of data, which isn't what I'm trying to do.
1 Reply
- One alternative option is using MS form or similar online form to collect info.
what is Box?(LAN Share folder share excel file)?
