I have an excel file containing rows where some of them are "historical data" of other rows. in other words, they have the same "key" but different attribute values. I would like to import them into a list with versioning activated so that when there the same key is loaded, it becomes a new version of an exsiting row.
Is that even possible ?
Example: Column A (key), B, C Record1: X, abc, abc Record2: X, abc, def Record3: Y, ggg, hhh
After upload, I would like to see only 2 rows in the SharePoint list for records X and Y where X would have some history.
Help welcome