Replace immediate next cell value with NULL for reoccuring row value

[mzahid (Zahid)]

I just want to replace the reoccurring values from the Column “Col2” with null values in my output table as shown below, please help

Exercise1.xlsx (8.8 KB)

[Yoichi]

Hi,

Hope the following helps you.

Sample20200527-1.zip (23.9 KB)

Regards,

[mzahid (Zahid)]

Thank you soo much @Yoichi , that worked well.