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
flashing a white screen while open new tab
cntvertex in Discussions on
13 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
22 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies
Edge insider Dev bypasses IE mode website list
HotCakeX in Enterprise on
4 Replies