Hi, I have 5 columns that I am trying to make into 1. Each row should basically contain the same data but that data can be placed anywhere in Columns 1-5. For example, if row 1 has its value in column 4 then the rest of the columns should be null or blank. My current formula works until column 3 only (not sure why). Any idea? Sample: Col 1Col 2Col 3Col 4Col 5Expectationa a a b b c c dd dd e e My Formula: if isnull ([col 1]) then [col 2] elseif isnull ([col 1]) and isnull ([col 2]) then [col 3] elseif isnull ([col 1]) and isnull ([col 2]) and isnull ([col 3]) then [col 4] elseif isnull ([col 1]) and isnull ([col 2]) and isnull ([col 3]) and isnull ([col 4]) then [col 5] else [col 1] endif Thank you.

How to get a column value when the rest is null or blank?

Hi,

I have 5 columns that I am trying to make into 1. Each row should basically contain the same data but that data can be placed anywhere in Columns 1-5. For example, if row 1 has its value in column 4 then the rest of the columns should be null or blank. My current formula works until column 3 only (not sure why). Any idea?