This article is the outcome of my answer to this question in the MSDN SSRS forum .

Example :

Consider below query is my dataset :

DECLARE  @sample_data table
(
Name varchar(50),
AgeYears INT,
WeightPounds INT,
HeightInches INT
)
insert @sample_data SELECT  'Anna',84,90,60
insert @sample_data SELECT  'sarah',38,120,67
SELECT * FROM @sample_data

If we need columns AgeYears,WeightPounds,HeightInches horizontally stacked in one row cell :

Add a Matrix , Under Rows add Name field  and then Insert Row - > Inside Group -  Below  as shown in below image: (similarly add two more rows)




Under Columns - > Data : Below is the expressions for three inserted rows :

="Age"+Space(3)+CStr(Fields!AgeYears.Value)
="Weight"+Space(3)+Cstr(Fields!WeightPounds.Value)
="Height"+Space(3)+Cstr(Fields!HeightInches.Value)
After formattings and alignment , if we Click on Preview tab , we can notice the expected report as shown in below image :





If we don't need lines in between Age,Weight & Height , then add Tablix with two columns Name and Stats
With Name value  =Fields!Name.Value
& Stats Value  ="Age " + Cstr(Fields!AgeYears.Value) + VBCRLF + "Weight " + Cstr(Fields!WeightPounds.Value) + VBCRLF
+ "Height " + Cstr(Fields!HeightInches.Value)

 

 

After formattings and alignment , if we Click on Preview tab , we can notice the expected report as shown in below image :