Pivot table

[#1]

Can i select values of an entity form two rows and disply combined result? Please suggest.

[#2]

if you type =

concat([Field Name],';') into a text box you will see all the selected values from a field delimited by the second parameter ie ';'

[#3]

You can hold down the CTRL key while clicking the first row, then click the second row. When you let go of CTRL both rows will be selected. It depends on the type of object you are displaying and what you mean by "combined result".