The company i work for left the documentation of the hardware we use daily to us. In order to facilitate our search for specific items, one of my co-workers created an excel spreadsheet containing 11 columns and over 1000 rows. The columns are Location, Part Numer, Description, Other Locations, and then 7 columns dedicated to other numbers the hardware might use depending on the context needed.
The issue is that it is not a jointly edited document, she simply sends out a new iteration every so often with changes she has consolidated into the sheet.
What I’m wanting to know is:
1.) Is Libre capable of, and how do I, start with the oldest document, add in the data from the next iteration, then delete duplicates leaving only the consolidated data from the spreadsheet?
2.) Then sort the table as a whole by the FIRST column, LOCATION, and keep the rows together so the data moves with the location information.
I currently have 6 iterations that i would like to consolidate, and then i am looking to push it through MSTeams as a living document that all of us can view, edit and use as we need.
Thanks for any and all assistance.