+ Reply to Thread
Results 1 to 6 of 6

Flipping & Sorting Data

  1. #1
    Registered User
    Join Date
    01-20-2017
    Location
    USA
    MS-Off Ver
    13
    Posts
    4

    Question Flipping & Sorting Data

    Howdy. Newbie here and trying to find a way to flip the data from one column with many rows to 2 columns with multiple rows which satisfy the following criteria:

    let say my 1 column has the following data. There is a blank row after every 2 rows but I can eliminate the blank rows, if necessary to make it easier to get the issue resolved:

    A
    A1

    B
    B1

    C
    C1

    What I am looking to accomplish is Change 1 column of data to 2 columns, with data from the 2 adjacent rows (A & A1 or B& B1, etc.) split in 2 different columns but on same row.

    A A1
    B B1
    C C1

    Any assistance would be greatly appreciated.

    Thanks.
    Mark

  2. #2
    Forum Expert
    Join Date
    03-20-2015
    Location
    Primarily UK, sometimes NL
    MS-Off Ver
    Work: Office 365 / Home: Office 2010
    Posts
    2,405

    Re: Flipping & Sorting Data

    Assuming your data starts in A1, put this in B1:
    Formula: copy to clipboard
    Please Login or Register  to view this content.

    Drag that down as far as you need.
    (This only works if the blank rows are there, so don't remove them.)

    You can then copy column B and Paste Values over the formulae (click the down arrow below the 'Paste' button and select the 'Values' button - the one with just '123' shown on it).

    Then you can delete the now-unneeded rows.

    Hope that helps.
    Regards,
    Aardigspook

    I recently started a new job so am a bit busy and may not reply quickly. Sorry - it's not personal - I will reply eventually.
    If your problem is solved, please go to 'Thread Tools' above your first post and 'Mark this Thread as Solved'.
    If you use commas as your decimal separator (1,23 instead of 1.23) then please replace commas with semi-colons in your formulae.
    You don't need to give me rep if I helped, but a thank-you is nice.

  3. #3
    Forum Contributor
    Join Date
    12-18-2016
    Location
    London
    MS-Off Ver
    Microsoft 2013
    Posts
    145

    Re: Flipping & Sorting Data

    =concatenate(a1, " ", a2)
    Screen Shot 2017-01-20 at 10.07.28 PM.png

  4. #4
    Registered User
    Join Date
    01-20-2017
    Location
    USA
    MS-Off Ver
    13
    Posts
    4

    Re: Flipping & Sorting Data

    Thanks Aardigspook. That did it!

    Greatly appreciated.

  5. #5
    Registered User
    Join Date
    01-20-2017
    Location
    USA
    MS-Off Ver
    13
    Posts
    4

    Re: Flipping & Sorting Data

    Thanks for your reply Amanda. Perhaps due to my confusing original notes, the data in column B (A & A1, etc.) in your screenshot needs to be on separate columns.

    Thanks.

  6. #6
    Forum Expert
    Join Date
    03-20-2015
    Location
    Primarily UK, sometimes NL
    MS-Off Ver
    Work: Office 365 / Home: Office 2010
    Posts
    2,405

    Re: Flipping & Sorting Data

    I should have said earlier: welcome to the forum.
    Glad to be of help. Please take a moment to mark the thread as Solved so others know there's an answer here (instructions in my sig). Thanks.

+ 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. flipping of data in excel cell
    By Nasir Sajid in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-12-2012, 02:18 PM
  2. flipping (not transposing) data?
    By jspinx in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 11-18-2010, 08:17 PM
  3. Flipping data in a cell
    By maryjdelo in forum Excel General
    Replies: 5
    Last Post: 09-02-2009, 02:04 PM
  4. Flipping Data
    By RynMan in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 04-07-2009, 01:14 AM
  5. [SOLVED] importing data:Is there anyway of flipping this around.
    By abourg8646 via OfficeKB.com in forum Excel General
    Replies: 0
    Last Post: 04-24-2006, 10:10 AM
  6. [SOLVED] Data Flipping
    By Steph in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-01-2005, 04:09 PM
  7. [SOLVED] Data Flipping - Approach with formula?
    By Steph in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 11-01-2005, 04:09 PM
  8. [SOLVED] Data Flipping
    By alamsemu in forum Excel General
    Replies: 1
    Last Post: 03-10-2005, 02:07 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