Merging tables and entering merged values in individual lines within a cell
Tue, 05/19/2020 - 01:15 pm
I am merging 3 tables together. I need the cells of the merged table to come out in a certain format. So, let's assume that first cell of tables 1, 2 and 3 has values a, b and c respectively. My IGOR program merges the tables to give me "a,b,c" as the first cell of the merged table. However, now I want each value to be reported in a new line within the cell. So instead of a,b,c , I am looking for:
To do this, I tried adding "\r" ahead of b and c in my program but it hasn't helped. Attached is an image of the current output table, and also attached is an image of how I want the data to look. Current table output has the line change symbol ahead of b and c within each cell, but when I copy this table over to excel, the line change is not executed. Ultimately, I want to move this table to a word file. Kindly advise how to make this happen.
Thanks a lot,