Adding every two columns?

[lcrutch001]

I have a data set that needs to add every two columns together starting after column E. Not sure what's the best approach to this. Basically the first column that needs to be added to the proceeding column are values paid on the same date, then the next two columns should be added together. Ideally I would like to retain the data header after the two columns are added together.

I'm thinking maybe 1st scrub the text from the column headers and that would leave only the data. Then try to sum based on the fact that two columns will now have the same header?

Any ideas? This data set only ranges specific date range but other data coming in the future could have bigger date ranges. Hopefully I could turn this into a macro.

[clmc9601]

Hi @lcrutch001,

Would something like this work? It transposes all the date columns into a single column and then sums the ones that have the same date in the name.

 

[Qiu]

@lcrutch001 

There are some dates data that only contains Insurance Cost, not the Pay Cost. 

How to deal with that?