Sorting by 3 colors

[bryleek]

I want to sort by the 3 different time points. Ideally, the column would repeat baseline (green) 1 year (blue) 2 year (yellow) all the way down.

 

[Joe4]

Welcome to the Board!

Since each color seems to be aligned with a specific text value (the "eventname"), why not just sort by the "eventname"?

 

[bryleek]

Welcome to the Board!

Since each color seems to be aligned with a specific text value (the "eventname"), why not just sort by the "eventname"?

Hi! When I sort by "eventname" it puts 1 year together, baseline together, and 2 year together. Rather I want the order to repeat as each subject has three different time points and I want the subjects to stay together.

 

[Joe4]

Hi! When I sort by "eventname" it puts 1 year together, baseline together, and 2 year together. Rather I want the order to repeat as each subject has three different time points and I want the subjects to stay together.

I am not following what you want, as it relates to the rest of your data.
Please show us a "before" picture (what you have to start with) and an "after" picture (what you want it to look like when it is done).
That might help clarify exactly what you are trying to do.

 

[bryleek]

I am not following what you want, as it relates to the rest of your data.
Please show us a "before" picture (what you have to start with) and an "after" picture (what you want it to look like when it is done).
That might help clarify exactly what you are trying to do.

Of course! You'll notice rows 2-4 consist of the same subject ID (same participant) and their 3 timepoints are in the correct order (baseline, 1 year, 2 year). This is what I need! Some subjects are missing time points and only have 1 or 2 (which makes this even more difficult) and others have all 3 (ideal). I am needing the subject ID ordered in the correct time points they were seen (baseline, 1 year, 2 year). Right now I have the subjects ordered correctly but their time points are not. I can get rid of the color coding if there is another way to organize this.

 

[Joe4]

You should be able to do this with a Custom Sort.
Follow the instructions here: Sort data using a custom list - Microsoft Support

Your first sort field will be column A.
Your second sort field will be column B, and you set a Custom Sort order of "baseline, 1 year, 2 year"

 

[bryleek]

You should be able to do this with a Custom Sort.
Follow the instructions here: Sort data using a custom list - Microsoft Support

Your first sort field will be column A.
Your second sort field will be column B, and you set a Custom Sort order of "baseline, 1 year, 2 year"

This worked! Thank you so much. I really appreciate it!

 

[Joe4]

You are welcome!
Glad I was able to help.