https://community.qlik.com/t5/Connectivity-Data-Prep/comparing-with-previous-cells/m-p/1816559#M9170 <P>Hello,</P><P>I have 2 columns ('ID 1' and 'ID 2' )</P><P>If 'ID 2' is empty and the 'ID 1' is matching with 'ID 1' of the next not empty 'ID 2' above, I want this 'ID 2' instead of the empty field.</P><P>A little example for better understanding <span class="lia-unicode-emoji" title=":slightly_smiling_face:">🙂</span></P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="schuffe_0-1624278722424.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/57169i03A4C45D3211A115/image-size/medium?v=v2&amp;px=400" role="button" title="schuffe_0-1624278722424.png" alt="schuffe_0-1624278722424.png" /></span></P><P>Is this possible ?</P><P>&nbsp;</P> Mon, 21 Jun 2021 12:34:05 GMT schuffe 2021-06-21T12:34:05Z https://community.qlik.com/t5/Connectivity-Data-Prep/comparing-with-previous-cells/m-p/1816559#M9170 <P>Hello,</P><P>I have 2 columns ('ID 1' and 'ID 2' )</P><P>If 'ID 2' is empty and the 'ID 1' is matching with 'ID 1' of the next not empty 'ID 2' above, I want this 'ID 2' instead of the empty field.</P><P>A little example for better understanding <span class="lia-unicode-emoji" title=":slightly_smiling_face:">🙂</span></P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="schuffe_0-1624278722424.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/57169i03A4C45D3211A115/image-size/medium?v=v2&amp;px=400" role="button" title="schuffe_0-1624278722424.png" alt="schuffe_0-1624278722424.png" /></span></P><P>Is this possible ?</P><P>&nbsp;</P> Mon, 21 Jun 2021 12:34:05 GMT https://community.qlik.com/t5/Connectivity-Data-Prep/comparing-with-previous-cells/m-p/1816559#M9170 schuffe 2021-06-21T12:34:05Z https://community.qlik.com/t5/Connectivity-Data-Prep/comparing-with-previous-cells/m-p/1817020#M9179 <P>Hello&nbsp;<a href="https://community.qlik.com/t5/user/viewprofilepage/user-id/131489">@schuffe</a>&nbsp;</P><P>&nbsp;</P><P>Please have a look at another community thread:</P><P><A href="https://community.qlik.com/t5/New-to-Qlik-Sense/previous-and-merge-cells/td-p/1044476" target="_blank">Solved: previous and merge cells - Qlik Community - 1044476</A></P><P>&nbsp;</P><P>Thanks,</P><P>Padma Priya</P><P>Qlik Support</P> Tue, 22 Jun 2021 14:36:58 GMT https://community.qlik.com/t5/Connectivity-Data-Prep/comparing-with-previous-cells/m-p/1817020#M9179 PadmaPriya 2021-06-22T14:36:58Z https://community.qlik.com/t5/Connectivity-Data-Prep/comparing-with-previous-cells/m-p/1817504#M9187 <P>Thank You. This will help <span class="lia-unicode-emoji" title=":slightly_smiling_face:">🙂</span></P> Thu, 24 Jun 2021 05:52:18 GMT https://community.qlik.com/t5/Connectivity-Data-Prep/comparing-with-previous-cells/m-p/1817504#M9187 schuffe 2021-06-24T05:52:18Z