Hope you all are doing well.I have to write data from an excel to file.Let us consider that the excel has 2 columns L1 and L2.There are 3 rows R1,R2 and R3. The cells are R1L1, R1L2,R2L1 and so on.
Suppose the data in R1L1 and R2L1 are the same.So these two cells are merged into a cell say R1R2L1.
When the data is to be written to a file,it has to be done as follows:
Data for row R1 -> R1R2L1 R1L2
Data for row R2 -> R1R2L1 R2L2
Data for row R3 -> R3L1 R3L2
Please suggest how I can achieve the above objective.