SQL Server 2019
1 TopicHow to merge empty cells when exporting report to excel
Hi All, Please see the below screen shot, when I export the report in excel the user sees the report in the below format. If you see column A has only data in ROW 2 , column B has data in ROW 2 and 3, column C has data in all the 3 rows. Is it possible in case of column A if ROW1 and ROW 3 is empty , it should merge all the 3 rows as one, similarly for column B ROW 1 is empty so merge all 3 rows, column C will not be changed as it has verbage for each row. Hope I did explain good. Thanks199Views0likes0Comments