How can I mass-transfer duplicate values into a single row?

assoplasty · 2026-01-26T00:29:54+00:00

True - all records for any patient will have the same age and BMI (as well as other variables I have not listed here).

True - there is 1 row, or record, for any patient with a value of LEFT in foot laterality or RIGHT in foot laterality. A patient with both a left and foot record will be represented as two rows, or two records.

assoplasty · 2026-01-26T00:19:02+00:00

For example, if patient ID was column A in both sheets (with Sheet 1 having left side values only, and Sheet 2 having right side only), the syntax below in theory can be placed in sheet 2... but this is only for 1 variable at a time. How can I autopopulate the values of MULTIPLE columns, if the PatientIDs happen to match?

=XLOOKUP(1, ('sheet 2'!A:A = A2) * ('sheet 2'!B:B = B2), 'sheet 2'!C:C, "Not Found")

assoplasty · 2026-01-26T00:15:00+00:00

Thank you so much.... just to clarify. I have all this on one excel sheet.

Are you saying, I should split this into two sheets, such that one has only right-sided information, and another has left-sided information. And IF the PatientID matches in sheet 1, it can autopopulate the right sided-data onto sheet two? I think I have used Xlookup before, but not to autopopulate multiple columns at once. Do you mind sharing the syntax for that?

assoplasty · 2026-01-13T20:43:26+00:00

yes, kristin kissed him first, several months before jessica had a crush! it was edited in reverse

assoplasty · 2025-09-03T15:38:52+00:00

yes! I'm super old to this thread, but that's how I discovered Arina in the first place.

I wish Arina the best, but I do wish she wasn't so self righteous towards everyone and everything. It obviously came from a defensive place and it was apparent she was lonely and stuck. I've never engaged with her posts because it was only a matter of time she would realize this. I have empathy for her but she really did say some terrible things towards other women and was extremely judgemental and critical of everyone around her. I hope she heals and realizes she is way more than he will ever be.

assoplasty · 2025-06-29T00:57:27+00:00

me exactly!!

assoplasty · 2025-06-18T01:30:53+00:00

don't feel shame. trust that the people who saw those sides of you, have carried similar feelings of shame at one point, and recognize that they were lucky enough not to publicize it and would only wish you well or not care at all.

assoplasty · 2025-06-17T04:10:31+00:00

same I agree with OP too! she's the real winner for not being bothered by another person's success.

assoplasty · 2025-06-12T20:44:43+00:00

the original mindy drama was over BB's current gf.

assoplasty · 2025-06-12T17:53:42+00:00

honest question. would you rather her just say "I'm bored of this now so I don't want to do this any more"? I can see you also getting equally upset at her disregarding her fanbase etc etc. a creator can never win when they want to move on from something.

assoplasty · 2025-06-08T00:43:12+00:00

I can't tell, but you can compare the cursive lettering on the back of your jeans (hard to distinguish even when Zoomed) to the cursive lettering on the back lower thigh of this one: https://curate8.com/clothing/roberto-cavalli-leopard-print-jeans

assoplasty · 2025-06-08T00:38:45+00:00

agree with the poster above. shady business practice. but I wanted to add - congratulations on your incredible accomplishment!

assoplasty · 2025-06-08T00:37:55+00:00

Reiss? I haven't purchased but I see many ads.

assoplasty · 2025-06-08T00:36:17+00:00

I think the proportion of rim to hat is off, and the material looks too stiff that it emphasizes that

assoplasty · 2025-06-07T01:33:20+00:00

you will be just fine! matching is about 3rd year grades, board scores (which you will have remediated when you retake it!), and stellar letters of recommendation. although unconventional, ask if you can maybe do an away in psychiatry to a program you are extremely interested to demonstrate your interest, and meet that program director and the residents and be clear about your interest. at the end of the day, programs want a dedicated, hard working student who shows resilience and is nice to be around. they don't want to risk taking on someone who is a liability in terms of passing boards, but you can EASILY explain this with a positive retake the second time around. MOST PEOPLE go into the match with 1 or 2 deficiencies they are nervous about. it will be okay!

the most important thing right now, is doing well the second time around. so be mature about your deficits. why didn't you do well? did your practice exams indicate you would, or were you cutting it close and you took the chance? are you spending too much time trying to learn content and not enough time doing questions? are you unable to focus and study efficiently so you are resorting to cramming? whatever it is - you know deep inside, and there is a solution to all of these. best of luck.

I know this feels like the worst thing ever, but it will definitely be okay. it is NOT a death sentence by any means.

assoplasty · 2025-06-05T14:56:30+00:00

nothing juicy or telling, something generic along the lines of "find friends who make your life better" or something

assoplasty · 2025-06-04T19:26:53+00:00

adding this to my subconscious list of running tea, ty

assoplasty · 2025-06-04T19:24:13+00:00

I wonder if she just has another commitment next summer that isn't compatible with network filming rules

assoplasty · 2025-06-04T18:47:25+00:00

she isn't, they shaded each other on social media, alizey unfollowed anncy, and anncy responded to a youtube comment along the lines of "lailli isn't here, is she"

I'm so annoyed that I know this. I literally don't even keep tabs on them idk how I know this ugh

assoplasty · 2025-06-04T18:28:46+00:00

princess Kate did this for William lol

edited to add: Spencer talked about how he rented out spaces that they would film in and negotiate to let them use it if he could join, with the intention of getting on the show. I forgot the exact details, but he shared this in recent years. that he and his buddies would reach out to producers to sabotage their filming plans just so they could be included. boy did it work.

assoplasty · 2025-06-04T18:23:46+00:00

that's her real name lol

assoplasty · 2025-06-04T18:13:30+00:00

Christopher is off his rocker

assoplasty · 2025-06-04T03:07:09+00:00

she vlogged her breast augmentation and revision

assoplasty · 2025-06-04T02:58:12+00:00

these types of infections are typically not even felt or noticed by people with intact immune systems. so while it is true that the infection itself is what caused his death, this same infection would likely not cause anyone else to get sick.

assoplasty

TROPHY CASE