We help IT Professionals succeed at work.
Get Started

Reorganize complicated Excel File - relocate columns

Last Modified: 2013-11-25


This might be a quite simple question to you, but it is quite complicated for me.
I have the attached excel with a list of patients filled with some parameters from testing equipment. To be more specific, we have a patient who comes to our office one day and we collect some data in six measurements. The patient visits our office another time and we repeat some measurements (2-6 measurements) recording the same dataset.
I want to be able to create a new table from this complicated one with the following characteristics:
- We will use only the following columns: C, D, K, L, M, N, O, AA, AB, AD, AE, AM, BV, BW, BX, BY, BZ, CO, CQ, CV, DC, DY.
- First of all we want the data to be sorted automatically by date and time on column D and then by column DY.
- Afterwards, for each appointment (certain day) we want ALL the data to be put in the SAME row. That is, we want data on column C, K, L, M, N, to be read once, and the rest of the desired columns to have the following format: D, O, DY, and then all the data collected on the specified time (column D) and position (column DY) (please see tab RESULTS on the attached excel to understand what I am saying).

If all these are understandable, please send me your comments.

It is a very crucial matter for me, because I must have this ready by Wednesday June 16, 2010.

Awaiting for your comments.
Watch Question
Top Expert 2015
This problem has been solved!
Unlock 1 Answer and 16 Comments.
See Answer
Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

  • Troubleshooting
  • Research
  • Professional Opinions
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE