BIP Excel Output Columns and rows Merge -Solution

 BIP report Properties >>Formatting >>Excel2007 output >>

Min column width :0.02

Keep Values in same Column :True

Table Auto Layout : 7.5

RTF level >>Table properties >>Cell>>Options >>Uncheck check box called WrAP Text