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

**URL:** <https://forum.uipath.com/t/topic/465263>\
**Category:** Activities\
**Tags:** question, excel, activities\
**Created:** [August 16, 2022, 12:45am UTC](https://forum.uipath.com/t/topic/465263 "2022-08-16T00:45:10Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![swkim](https://sea2.discourse-cdn.com/uipath/user_avatar/forum.uipath.com/swkim/32/176743_2.png) [@swkim](https://forum.uipath.com/u/swkim)\
**Post date:** [August 16, 2022, 12:45am UTC](https://forum.uipath.com/t/topic/465263/1 "2022-08-16T00:45:10Z")

</div>

안녕하세요 uipath 공부중입니다.  
엑셀파일에서 A행은 셀 병합되어있습니다.  
 ![화면 캡처 2022-08-16 093530](https://global.discourse-cdn.com/uipath/original/4X/e/d/5/ed5123b6a0e7ad9f38eeb0a8f68a4cba7f72ccc8.png)

다른엑셀파일은 리스트만 있습니다.  
 ![이름 테이블](https://global.discourse-cdn.com/uipath/original/4X/d/3/5/d358685b20561cd5c860e967ac28c1b4fcffc11d.png)

아래 사진처럼 데이터를 가져올수 있는 방법이 있을까요?  
 ![화면3](https://global.discourse-cdn.com/uipath/original/4X/a/f/6/af6794d4a0b177952577e0a004d8829b3c4b1a50.png)

---

<div class="post-metadata">

**Author:** ![ppr](https://sea2.discourse-cdn.com/uipath/user_avatar/forum.uipath.com/ppr/32/464097_2.png) [@ppr](https://forum.uipath.com/u/ppr)\
**Post date:** [August 16, 2022, 8:43am UTC](https://forum.uipath.com/t/topic/465263/2 "2022-08-16T08:43:59Z")

</div>

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

> [@How to match data between 3 columns](https://forum.uipath.com/t/how-to-match-data-between-3-columns/396518/9):
>
> when readin int the excel into a datatable (read range) we would expect following result Group1|1|true |2|True … so we would filling up the missing GroupX column values grouping the data on GroupDocs processing / evaluating the groups For filling up, have a starter help here: [FillUp\_BlockBlanks.xaml](https://forum.uipath.com/uploads/short-url/tVbI3NX23prdsJoiua4qiTHPsYb.xaml) (9.3 KB) Grouping data have alook here:

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

> [@\[HowTo\] Overview on different options for grouping data and processing the groups](https://forum.uipath.com/t/howto-overview-on-different-options-for-grouping-data-and-processing-the-groups/290708):
>
> This HowTo introduces on the different options for grouping data from a datatable in order to process the grouped data. Introduction Grouping data and processing the grouped data is a common scenario e.g. when the grouped data is to aggregate like summing up, find maximum, get the average or concatening items. Lets have a look on following data: [grafik] A possible scenario could be: Create a report containing following information: the region code the sum of CaseCount per RegionCode th…
