+ Reply to Thread
Results 1 to 2 of 2

Multiple cells into one row

  1. #1
    Registered User
    Join Date
    01-04-2005
    Posts
    2

    Exclamation Multiple cells into one row

    Hi all,

    I'm sure this topic must have come up before but I couldn't find anything - apologies if you've read it all before.

    Basically, I have 2 columns - one with an ID and the other with another different ID. Each of the IDs in the second column is unique and are related to an ID in the first column like this:

    89 4652
    89 8979
    89 9567
    141 5025
    141 6521
    189 5684

    Is there a way of changing this so that I only have one row for each ID in the first column, and then all the relevant IDs from the second column are listed in seperate columns like this:

    89 4652 8979 9567
    141 5025 6521
    189 5684

    Thanks for reading my post - I hope you can help!

  2. #2
    Registered User
    Join Date
    01-04-2005
    Posts
    2

    Smile My reply!

    It's ok! I've worked out how to do it based on this formula:

    =IF(A2<>A1,B2,C1&","&B2)

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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