Column titles into values?

[far972]

Hello All,

I have a series of columns titled A,B,C,D that I would like to convert their titles into values for a new column, E.

Is there a simple way to do this in Report Studio?

TIA,
Mike

[jahnavi]

Concatenate all the columns into one dataitem

[Sreeni P]

Use UNION , and concatenate those data item into a single data item value, hope this will work..as per ur requirement