Entering information from tables into reports

I have a scheme based mainly on tables.  I therefore need to get information from a table column into a report column.

I don't seem to be able to just reference a table column in a report.

It looks as though it is necessary to specify the number of rows from the table.  Is this correct ?

When I do this, I separate each entry with a " / " by using the following command:

'[Cameras_Make_Row#0_Value]' + IF([Cameras_Make_Row#1_Value].Length > 0,' / '+'[Cameras_Make_Row#1_Value]','')+ IF([Cameras_Make_Row#2_Value].Length > 0,' / '+'[Cameras_Make_Row#2_Value]','')+ IF([Cameras_Make_Row#3_Value].Length > 0,' / '+'[Cameras_Make_Row#3_Value]','')+ IF([Cameras_Make_Row#4_Value].Length > 0,' / '+'[Cameras_Make_Row#4_Value]','')+ IF([Cameras_Make_Row#5_Value].Length > 0,' / '+'[Cameras_Make_Row#5_Value]','')+ IF([Cameras_Make_Row#6_Value].Length > 0,' / '+'[Cameras_Make_Row#6_Value]','')+ IF([Cameras_Make_Row#7_Value].Length > 0,' / '+'[Cameras_Make_Row#7_Value]','')+ IF([Cameras_Make_Row#8_Value].Length > 0,' / '+'[Cameras_Make_Row#8_Value]','')+ IF([Cameras_Make_Row#9_Value].Length > 0,' / '+'[Cameras_Make_Row#9_Value]','')

When this is entered onto the report and exported into excel it isn't very easy on the eye, we would have a number of columns with a number of rows, and the rows should all line up in the reports.

I tried adding a carriage return as this would be easier to read in excel but the <br /> command is displayed in excel.

Is there a way to dump the contents of a column into a report ?

Or is there a way of entering a carriage return that will not show up in excel ?

I look forward to hearing from you.