Copy Data from one row to the other

Hi Everyone,

I have a data set where the number needs to be copied from one row to other row which has the same reference in another column.

I have attached the actual and expected sheet which, I hope, should help to provide context on what the expected results are

Data Investigation

Accepted answers

Hi, @RudrakshPandey

FYI.

录制_2024_03_08_13_58_10_784.gif

@RudrakshPandey

All comments

Hi, @RudrakshPandey

FYI.

录制_2024_03_08_13_58_10_784.gif

Brilliant. That worked. Thanks

@RudrakshPandey

Your formula works directly. but if there are times when the data in the same group is empty in the previous row and the current row has data, and sometimes the previous row has data and the current row is empty, a more flexible solution is needed. 🤝

Quick Links

Tags

This months top contributors

atcodedog05 19458

Qiu 15866

MarqueeCrew 13708

apathetichell 13703