I currently have 4 columns that contain data on Bitcoin Prices and S&P 500 closing day values, as well as their respective dates:
Since the S&P 500 is closed on non-trading days and the Bitcoin market is open 24/7, the amount of data I have for each is unequal; I have way more days for Bitcoin than for the S&P 500.
I want to compare the two columns containing their dates, extract the dates that are matching in both columns, and then output the matches and their corresponding values into a separate column.
Please let me know if any of this is unclear.