I Need Help merging data from multiple custom columns

[thejoker954]

Ok, so I have 4 custom columns that I would like to merge into 2 columns.

I have two columns from Calibre Companion. One column is a simple yes/no for read status and another column that displays the date it was read.

The other 2 columns are from my kindle. these 2 columns are built off of https://www.mobileread.com/forums/sh...31#post1353631 (displays date read,reading:%,Not Read) and it's counterpart https://www.mobileread.com/forums/sh...&postcount=172 ( displays "Read" instead of the date,Reading:%, Not Read)

What I'd like to do is take the read dates from the CC date column and the read date from the kindle column built from the first thread and merge them into a single column.

Then I want to do basically the same thing for the CC read column and the kindle column built from the second thread and merge them

In the end I'm trying to get one column that displays if it was read (I don't care if it does or doesn't display not read or reading:% like it does in the kindle columns built from those posts) and then a column that displays the date it was read.