Get all the values in a single line

[Vinay_47]

 

I had a group named Airtel and it had a date called standby date and it has values from 01-01-25 till 31-01-25

I have added columns for current date -2, current date -1 , current date , current date +1 , current date +2 ,followed by +3,+4,+5

My requirement is if there is standby date which equals my above current date column values then it should have X else it should be null. The groups should not be duplicated  as per the screenshot. It should come in a single line.

Attached screen shot for reference

[ayman_salem]

Is every Airtel has multi -standby date?
Are you defined for each column a variable/formula (8 variable for 8 columns) or have you received it from your data?

An example -raw data and the variable you defined are useful to correctly understand your question and give you the correct answer:

[Vinay_47]

Yes it has multi values for stand by date. Yes each column is created with 8 different variables.