Feb 27 2023 01:45 PM
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.
Feb 27 2023 06:41 PM