Transposing a row formula help

[wonka1234]

hi,

i need help with my "Comment" field.

I use the formula for comment field =:

If
!IsNull([Test1]) Or !IsNull([Test2])
then "Field Requires a Value"
elseif !IsNull([Test3]) then 'Approval is wrong'
Else ""
EndIf

to get this:

then when I transpose I only get the one comment. 

beside approval should be "approval is wrong".

Not sure how to configure this..

Do I need two comment fields?

[michelle_mathews]

Hi @wonka1234 , can you attach a sample of your original data? The words "approval is wrong" do not appear after the data is transposed, because they also do not appear in the data before it's transposed, or at least in the 1 line of data you screenshotted. 

[wonka1234]

@michelle_mathews that is my original data unformately. I need the comment "approval is wrong" beside the approval row somehow..

[michelle_mathews]

@wonka1234 , in your formula you are referencing columns called Test1, Test2 and Test3. Do you have that data available to share?

[michelle_mathews]

@wonka1234 , it would say 'approval is wrong' if in fact that's what it said in the first cell before you transpose. But your data says 'Approval' in that first cell not "Approval is wrong". Your formula is for your Comment field, but perhaps you need to apply a formula on your Approval field instead.  

Attaching an example