How to change or replace multiple cell name in Microsoft Excel chronologically?

I have provided the screenshot of my excel worksheet. I want to rename the cells in column B chronologically same as Column A but without losing the blank cells. i.e the first "transfer" name cell of column B will be "transfer 1", the second "transfer" name cell of column B will be "transfer 2", the third one will be "transfer 3" and so on. Is that possible? If so how and is there a easy method to do that? Also if that is not possible, is there a way to arrange the cell of Column A same as Column B. i.e arranging the cells of column A exactly like column B and have those blank cells in between.

I am complete noob at excel so please be detailed with your answers if possible. Thank you.

I have tried several formulas and methods but none of them gave me the desired result that I expected. I have not tried VBA though because I dont know how to use it.

excel.JPG

I guess in C2 and copy down.

Please Login or Register  to view this content.

It is just random not logic based. I want to use the method or formula on my main worksheet. This is just a sample.

I think this will work for me. Thank you. I will mark the thread as solved but I need to check first if this will also work on my main sheet as intended but I think this should work. This is what I was looking for.

You are welcome.

It works great but is there a way to change the starting number to something else instead of 1. Lets say I want the starting number to be 38 and follow the chronological order which is 38, 39, 40 etc. It should be same as the previous one but the starting number will be different. Is it possible by tweaking something in your formula? Thanks.