Combine contents of multiple columns into one

building reports
1

Hi,
I’ve done this in the past, but it’s been so long I can’t remember the formula I used.

I want to take these 4 columns for Race and make 1 column, where if “1” is present that text will appear in the new column so I can remove the original 4.

This is what I have:
ID White Black Asian Unknown
001 1 0 0 0
002 0 1 0 0
003 0 0 1 0
004 0 0 0 1

This is what I would like:
ID Race
001 White
002 Black
003 Asian
004 Not Reported

My goal is to make the report less “busy”. I do recall using some kind of “IF” function, I just can’t remember how to write it all out.

Any help would be greatly appreciated.

THANKS!!!

2

I’ve been able to locate my notes and completed the task. If anyone would like this info, please reach out.

3

Yes, please post your solution. this will be helpful to others in the future if they come across this post. Thanks!