Forum Discussion
amybi77
Mar 11, 2024Copper Contributor
How 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.
Thanks
No RepliesBe the first to reply