Forum Discussion
Taking a large amount of Date with multiple lines from one column to two?
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
BQ-4934 , that's job for Power Query. Please see Sheet 3 attached - if I understood your logic correctly.
- 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?
