I have financial data (for daily yields to maturity for 296 different german government bonds) and want to divide my excel sheet into two different clean csv files. There should be ONE column with dates in column "A" ranging from [url removed, login to view] to 08.05.2017. You should use the first column in the provided file to copy it into each csv, as it is already prepared, just using all days in the timeframe will not work as it will skew the rows (only trading days are in the sample). You should deliver one csv file containing the YTM BID only yields and another one the YTM ASK only yields, fitting to the dates in column A. The column header for each column with yields shall be the identifier (e.g. "EK080950 Corp "). As the date for each first yield for each bond is formula that won't exectue, the date is an error there. This first entry of each bond may be either deleted or the date prior to the next date may be used for it.