Sorting variables from a file and creating table with some data

Hi,

I am looking for a Macro:

For each contact ID, first and second occurrence, we want to isolate the following variables:
CHAIR_STAND
ARM_CURL
UP_AND_GO

If someone has only one record they would not be included in output table. If they have more than 2 records, only the first two (with CASE_DATE sorted oldest to newest) would be included in output. The output table would look something like this

CONTACT_ID CHAIR_STAND1 CHAIR_STAND2 ARM_CURL1 ARM_CURL2 UP_AND_GO1 UP_AND_GO2


Thank you so much,
Ajang

See if this is what you wanted

Yes, I want this but the code is password protected and I cannot view it in the file. Can you please make macro enable for view.

Thank you

Here's a code

Please Login or Register  to view this content.

Hi Jindon,

I am a student and work for a professor. We do not want column of both and difference. Apart from that the macro works perfectly. Thank you.