Match columns of a new and old spreadsheet and then input data into new...

kernel_kate

I have spreadsheet (spreadsheet A) with multiple columns containing data plus a column at the end containing data with comments. I have a new spreadsheet (spreadsheet B) with all the same columns of data but the column at the end does not contain any data with comments. I would like to do the following: If the IP address in spreadsheet A matches the IP address in spreadsheet B, then add the corresponding comment from spreadsheet A to the comment...

Originally asked by ITguru1 on Stack Exchange (unix) (CC BY-SA 4.0).

uphilltech

Good thread on this — worth a read before you pay anyone to build it.

Discussion: https://unix.stackexchange.com/questions/517583/match-columns-of-a-new-and-old-spreadsheet-and-then-input-data-into-new-spreadsh.

Want it set up for you? UphillTech.