Taking a large amount of Date with multiple lines from one column to two?

Highlighted
Occasional Visitor

I have a spreadsheet, see below, that consist of approximately 5000 rows.  The data found in column A,  I want every other row to go into column B.  Can someone tell me a simple way to do this?  There is too much data to use Transpose or Cells to Columns function.

 

I would be forever grateful for help solving this!!!!

 

2 Replies
For some of your desired results in Column B of Sheet 2, I see no relationship between those results and the values in Column A. For example, how did you determine "Austria" in B7, B8, B14, B16, B18, and B20?
Highlighted

@BQ-4934 , that's job for Power Query. Please see Sheet 3 attached  - if I understood your logic correctly.