IF Statement with data from one column populating another.

[Adam_B]

Hello,

I have a data set with a column named "How Many SBRs were done for Q1?" I need to populate the result of that column (can be 1-9) into a new column called Q1 with the respective number from the other column. 

Attached is dummy data.  

I believe it will be multiple IF statements for the range that I need, but I am not sure. 

[binu_acs · Accepted solution]

@Adam_B Not sure I understand your requirement. Is that something you are looking for?

[Adam_B]

@binu_acs Thank you!