I have the data below.
I need row 2-5 to be 017 and row 7-8 to be 088.
I used multi-row function
but the result is as below.
Why is the formula only applying to one row only? How to fix it? Thank you!
Solved! Go to Solution.
Exactly! This is amazing! Thank you!