Home

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

%3CLINGO-SUB%20id%3D%22lingo-sub-553649%22%20slang%3D%22en-US%22%3ETaking%20a%20large%20amount%20of%20Date%20with%20multiple%20lines%20from%20one%20column%20to%20two%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-553649%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20a%20spreadsheet%2C%20see%20below%2C%20that%20consist%20of%20approximately%205000%20rows.%26nbsp%3B%20The%20data%20found%20in%20column%20A%2C%26nbsp%3B%20I%20want%20every%20other%20row%20to%20go%20into%20column%20B.%26nbsp%3B%20Can%20someone%20tell%20me%20a%20simple%20way%20to%20do%20this%3F%26nbsp%3B%20There%20is%20too%20much%20data%20to%20use%20Transpose%20or%20Cells%20to%20Columns%20function.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20would%20be%20forever%20grateful%20for%20help%20solving%20this!!!!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-553649%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-556404%22%20slang%3D%22en-US%22%3ERe%3A%20Taking%20a%20large%20amount%20of%20Date%20with%20multiple%20lines%20from%20one%20column%20to%20two%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-556404%22%20slang%3D%22en-US%22%3EFor%20some%20of%20your%20desired%20results%20in%20Column%20B%20of%20Sheet%202%2C%20I%20see%20no%20relationship%20between%20those%20results%20and%20the%20values%20in%20Column%20A.%20For%20example%2C%20how%20did%20you%20determine%20%22Austria%22%20in%20B7%2C%20B8%2C%20B14%2C%20B16%2C%20B18%2C%20and%20B20%3F%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-560822%22%20slang%3D%22en-US%22%3ERe%3A%20Taking%20a%20large%20amount%20of%20Date%20with%20multiple%20lines%20from%20one%20column%20to%20two%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-560822%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F339274%22%20target%3D%22_blank%22%3E%40BQ-4934%3C%2FA%3E%26nbsp%3B%2C%20that's%20job%20for%20Power%20Query.%20Please%20see%20Sheet%203%20attached%26nbsp%3B%20-%20if%20I%20understood%20your%20logic%20correctly.%3C%2FP%3E%3C%2FLINGO-BODY%3E
BQ-4934
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
Highlighted
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.

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
16 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
11 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies