Show field in spreadsheet view depending on other field value

Show field in spreadsheet view depending on other field value

Hello.

Not sure if this is possible but let's say i have spreadsheet view in Creator with four different fields 

Field A, B, C and D

Then i have a field named Response which for one record could contain only one of the pre-definde choices below

A, B, C or D

What i want to happen in the spreadsheet report view is depending on the value of the field Response only one of the 4 fields will be shown in the report.

I know this can be done in form view but i want to see this while the user is looking at many records at the same time.