May 09 2019 09:39 AM
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!!!!
May 09 2019 09:00 PM
May 11 2019 08:00 AM
@BQ-4934 , that's job for Power Query. Please see Sheet 3 attached - if I understood your logic correctly.