Hi,
I hope I put this in the right sub-forum.
I'm somewhat of a newbie in Access but I've managed to find my way reasonably well by trial & error and looking up a lot of stuff online. I'm currently facing a problem that I find difficult to solve though. I have a table that looks a bit like the one below here. The rows are all unique patient visits that have their respective patient ID and name, the date of the visit, a number of variables (I only added "echo_var" now) and for each patient their visits are ordered chronologically.
ID patientID patientname studydate echo_var echo_number 1 1234 Bob 01-01-2014 15 4 2 1234 Bob 01-01-2000 13 1 3 1234 Bob 03-08-2012 14 3 4 1234 Bob 13-02-2005 13 2 5 6625 Louie 12-11-2010 25 3 6 6625 Louie 08-10-1998 20 1 7 6625 Louie 19-04-2006 21 2
What I want to achieve is transform the data so it looks more like the table below, where each patient is on only one row and all the unique timepoints and the data obtained at that time point are displayed in columns (the actual amount of columns would depend on the number of visits).
patientID echo_number1 studydate1 echo_var1 echo_number2 study_date2 echo_var2 1234 1 01-01-2000 13 2 13-02-2005 13 6625 1 08-10-1998 20 2 19-04-2006 13