Results 1 to 11 of 11

Attempting to flatten multiple temporal data points for single identifier

Threaded View

  1. #1
    Registered User
    Join Date
    10-21-2013
    Location
    United States
    MS-Off Ver
    Excel 2013
    Posts
    6

    Attempting to flatten multiple temporal data points for single identifier

    Hello, and thanks for anyone taking a look at this. I'm not particularly good with excel, but have some limited knowledge. I am working on a medical research project involving taking information from patients for multiple days. On the first day they come in, the software that I use for data collection will attach all non-temporal characteristics of the patient in numerical form on that same row. Then each additional day the patient is recorded, it only records one number to indicate a single variable (marked level) on the sample attached. What I need to accomplish is to make it so that I can somehow flatten the entry to show only the maximum value for all recorded days in one line so that each patient has only one row. I have attached an excel with what it would look like before and after ideally. Really appreciate if anyone can help me with this!
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Multiple Data Points for a Single Day
    By SheilaV in forum Excel Charting & Pivots
    Replies: 11
    Last Post: 08-20-2019, 02:51 AM
  2. Need macro to search multiple data points from multiple entries and return single value
    By Redbullmoo in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 09-11-2013, 02:16 AM
  3. Lookup multiple data points to find info in a single cell
    By cradams72 in forum Excel General
    Replies: 1
    Last Post: 08-17-2011, 10:51 AM
  4. Evaluate Multiple Data Points Against Single Criteria
    By fmulvaney in forum Excel General
    Replies: 3
    Last Post: 08-31-2010, 03:26 PM
  5. Pie Chart plotting 1 single color for multiple data points
    By moonseed in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 11-12-2008, 03:41 PM

Tags for this Thread

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