|You didn't include Row numbers for your column B output, so I'll assume a Column heading in Row 1 such that Mumbai should end up in B2.|
Let's start with a Helper Column. You can put this column anywhere you like, I'll put it in Column C for simplicity sake.
In C1, enter this formula and drag it down as far as you need:
(Since you need every 9th row, you'll need 1/9th the total number of rows in Column A that contain data)
In Column C you should see this:
In B2, enter this formula and drag it down as far as you need:
What this will do is return the value in the cell that is OFFSET from A5 by the number of rows showing in C1, C2, C3, etc. Since Column C is incremented by 9 each time, the Column B formula will return ever 9th entry from Column A, starting from A5.
You can then do an Edit...PasteSpecial - Values if you want to lock the text into Column B, and then delete the Helper Column.
Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.