+ Reply to Thread
Results 1 to 2 of 2

Organizing Information in excel line to column (need this for work)

Hybrid View

  1. #1
    Registered User
    Join Date
    06-22-2015
    Location
    lisbon
    MS-Off Ver
    windows 8
    Posts
    33

    Organizing Information in excel line to column (need this for work)

    Hi,

    For example I have two lines like this:

    AAAAAAAAAAAAB
    AAAB

    Now I want to construct a single column with all the A's from both lines (the copy of the line must stop when I find B):

    How do I do this? I can for instance give a name to each line, like link1 and link2 if you find helpful. I also have to work with several links (it may be 20 lines), so if possible avoid array formulas.

    Thank you in advance,

    And happy new year

  2. #2
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Office 2019 (still learning)
    Posts
    25,408

    Re: Organizing Information in excel line to column (need this for work)

    No need to double post - I have replied to your other one.

    Pete

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 1
    Last Post: 01-05-2016, 05:42 PM
  2. [SOLVED] Organizing Information in excel (need this for work)
    By campelliann in forum Excel General
    Replies: 10
    Last Post: 01-02-2016, 09:53 PM
  3. Information from column to line without shiftting the cells
    By kuzna26 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 01-13-2014, 10:55 AM
  4. Column to line without shifting the information: I REALLY NEED IT
    By kuzna26 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 01-13-2014, 10:54 AM
  5. [SOLVED] Organizing Information
    By gsoundinc in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 04-19-2013, 01:50 PM
  6. [SOLVED] Organizing excel information into multiple lines
    By bryster126 in forum Excel General
    Replies: 12
    Last Post: 04-26-2012, 10:24 PM
  7. [SOLVED] My Custom Line-Column 2 axes Chart dsn't work with +6sets of cells
    By Tim in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 08-08-2005, 03:05 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1