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

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?

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