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!!!!
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?