+ Reply to Thread
Results 1 to 6 of 6

Column Data on Multiple Rows

  1. #1
    Registered User
    Join Date
    10-13-2015
    Location
    Johnson City, TN
    MS-Off Ver
    2010
    Posts
    7

    Column Data on Multiple Rows

    Column B contains a client identifier. The other columns track turnaround time. I need to get these columns to line up in one row per encounter. For many, one client number = one encounter but many clients have multiple encounters. Any help would be appreciated!
    Attached Images Attached Images
    Last edited by solagratia28; 08-30-2016 at 08:20 PM.

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

    Re: Column Data on Multiple Rows

    It would help if you attached a sample Excel workbook.

    To do this, click on Go Advanced (below the Edit Window) while you are composing a reply, then scroll down to and click on Manage Attachments and the Upload window will open. Click on Browse and navigate to (and double-click) the file icon that you want to attach, then click on Upload and Close this Window to return to the Edit window. When you have finished composing your post, click on Submit Post.

    Pete

  3. #3
    Registered User
    Join Date
    10-13-2015
    Location
    Johnson City, TN
    MS-Off Ver
    2010
    Posts
    7

    Re: Column Data on Multiple Rows

    File Attached.
    Attached Files Attached Files

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

    Re: Column Data on Multiple Rows

    First of all, you can select the cells d2:g2 and then click on delete. Then select cells d2:e2 and click on delete. That will align the times correctly, but you will have several rows that are effectively blank (i.e. no times in them). You could introduce a formula like this in cell I2:

    =IF(COUNT(D2:H2)=0,"delete","")

    and copy down to the bottom of your data. Then apply autofilter to this column, selecting "delete" from the filter drop-down. Highlight (i.e. select) all the visible rows while the filter is active and click delete. It might look like all your data has gone, but if you select All in the filter drop-down you will see that the data is now all bunched up. You can delete column I.

    Hope this helps.

    Pete

  5. #5
    Registered User
    Join Date
    10-13-2015
    Location
    Johnson City, TN
    MS-Off Ver
    2010
    Posts
    7

    Re: Column Data on Multiple Rows

    That was easier than I was making it! Thank you!

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

    Re: Column Data on Multiple Rows

    You're welcome - glad to help. Thanks for the rep.

    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. [SOLVED] Attemting to take a column of data and append it to multiple rows of data on another sheet
    By JamesJohnson31 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-17-2016, 10:34 AM
  2. Replies: 9
    Last Post: 11-11-2015, 08:19 PM
  3. Replies: 7
    Last Post: 10-03-2014, 05:04 AM
  4. Combine Data in Multiple Columns to One Column Based on Data in Rows
    By exceldivx in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 09-09-2014, 07:35 AM
  5. Replies: 4
    Last Post: 06-08-2012, 03:24 PM
  6. Replies: 5
    Last Post: 02-07-2012, 04:55 PM
  7. create multiple column rows starting from data in one column
    By thotosch in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 02-03-2012, 01:20 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