엑셀에서 병합된 셀 데이터 추출

we assume that a read range will split the merged rows with a result

| A

 | B
 | C

xx | 1
| 2
| 3

then we fill up the empty Col1 lines

the result would be:

| A

| B

| C

xx | 1
xx | 2
xx | 3

then we group the data on first column and will concat the group members