Manipulate data in excel to order results per a certain column



I want to make the information in some columns (but not all) displaying in rows, please see below an example.


This is what I have:


Patient          Visit 1       Visit 2     Visit 3      Visit 4(…)

1                   22Dec     12Jan         03Feb

2                   23Jan       03Feb        01Mar

3                   10Dec       03Jan        23Jan


(etc, long database with hundreds of patients)


This is how I want it to look like:

Patient       Visit type        Date

1                Visit 1            22Dec

1                 Visit 2           12Jan

1                 Visit 3           03Feb

2                 Visit 1           23Jan

2                  Visit 2         (…)



It doesn’t involve any calculation, it’s just data manipulation, basically ordering the visits per patient, but I am not sure of any function that does this, tried pivot table but doesn’t seem to do it quite like this… Any suggestions?  If there are no formulas, no buttons, etc, perhaps can you suggest a macro?      

Many thanks!

By: Ricardo

11 thoughts on “Manipulate data in excel to order results per a certain column

  1. Acquistare Methitolone itanthate

    After examine a couple of of the weblog posts in your web site now, and I actually like your method of blogging. I bookmarked it to my bookmark website list and might be checking back soon. Pls take a look at my website online as well and let me know what you think.

  2. Acheter Drostanolone enanthate

    I have been exploring for a little for any high-quality articles or blog posts in this kind of space . Exploring in Yahoo I finally stumbled upon this site. Reading this information So i am glad to exhibit that I’ve an incredibly just right uncanny feeling I discovered just what I needed. I such a lot definitely will make sure to do not fail to remember this site and provides it a look regularly.

  3. ig

    Have you ever thought about adding a little bit
    more than just your articles? I mean, what you say is important and all.
    But imagine if you added some great visuals or video
    clips to give your posts more, “pop”! Your content is excellent
    but with images and video clips, this site could undeniably be one of the
    most beneficial in its niche. Very good blog!

  4. CBD For Lip

    This web site is really a walk-through for all of the info you wanted about this and didn’t know who to ask. Glimpse here, and you’ll definitely discover it.

  5. site url

    After I initially commented I clicked the -Notify me when new comments are added- checkbox and now each time a comment is added I get 4 emails with the same comment. Is there any way you can take away me from that service? Thanks!

  6. Buy Supplements

    Hi, I think your site might be having browser compatibility issues. When I look at your website in Safari, it looks fine but when opening in Internet Explorer, it has some overlapping. I just wanted to give you a quick heads up! Other then that, fantastic blog!

  7. vurtilopmer

    Hiya, I am really glad I’ve found this info. Nowadays bloggers publish just about gossips and net and this is actually annoying. A good website with interesting content, that is what I need. Thanks for keeping this web site, I will be visiting it. Do you do newsletters? Cant find it.

Comments are closed.