# How can I fill in the NA columns with the duplicated rows then remove the duplicated rows?

**URL:** <https://community.exploratory.io/t/how-can-i-fill-in-the-na-columns-with-the-duplicated-rows-then-remove-the-duplicated-rows/3824>\
**Category:** HowTo\
**Created:** [October 25, 2024, 4:53pm UTC](https://community.exploratory.io/t/how-can-i-fill-in-the-na-columns-with-the-duplicated-rows-then-remove-the-duplicated-rows/3824 "2024-10-25T16:53:36Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![Kan\_Nishida](https://community.exploratory.io/user_avatar/community.exploratory.io/kan_nishida/32/14_2.png) [@Kan\_Nishida](https://community.exploratory.io/u/Kan_Nishida)\
**Post date:** [October 25, 2024, 4:53pm UTC](https://community.exploratory.io/t/how-can-i-fill-in-the-na-columns-with-the-duplicated-rows-then-remove-the-duplicated-rows/3824/1 "2024-10-25T16:53:36Z")

</div>

You want to group the data by something like Customer ID (or name) first.

 ![image](https://community.exploratory.io/uploads/default/original/2X/4/42fc3e93a39978cfde066abffcf43fa71971dcbf.jpeg)

Then, you want to use ‘Work with NA’ / ‘Fill NA with Previous / Next Row’.

 ![image](https://community.exploratory.io/uploads/default/original/2X/2/227a7beff685688167306b7ba343c0f3b49d1b3c.jpeg)

If the order inside the group is not what you expect, then you want to ‘Sort’ the data before doing the ‘Work with NA’.

After it’s done, don’t forget to ‘Ungroup’ , otherwise any subsequent operations will be driven by the group setting.

 ![image](https://community.exploratory.io/uploads/default/original/2X/4/41b06edab5ca690dd3d8e64ac1010ac9d7aae0b1.jpeg)

 ![image](https://community.exploratory.io/uploads/default/original/2X/0/03f89c49d3e8cc5423dfab352a917051d6efc969.jpeg)

After you fill the NA, then you can remove the duplicated rows!