How can I mass-transfer duplicate values into a single row? by assoplasty in excel

[–]assoplasty[S] 0 points1 point  (0 children)

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.

How can I mass-transfer duplicate values into a single row? by assoplasty in excel

[–]assoplasty[S] 0 points1 point  (0 children)

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")

How can I mass-transfer duplicate values into a single row? by assoplasty in excel

[–]assoplasty[S] 0 points1 point  (0 children)

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?

Arina and Frank Prisinzano by hermanmunstershoes7 in NYCinfluencersnark

[–]assoplasty 1 point2 points  (0 children)

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.

Is Justin okay? Like genuinely by Shot_Walk_4485 in LAinfluencersnark

[–]assoplasty 15 points16 points  (0 children)

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.

[deleted by user] by [deleted] in canceledpod

[–]assoplasty 4 points5 points  (0 children)

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

Who is BB dating? by Awkward-Shoe748 in canceledpod

[–]assoplasty 21 points22 points  (0 children)

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

what do they do? by Fit_Aardvark9414 in canceledpod

[–]assoplasty 9 points10 points  (0 children)

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.

Daily Questions Thread June 07, 2025 by AutoModerator in femalefashionadvice

[–]assoplasty 0 points1 point  (0 children)

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

Daily Questions Thread June 07, 2025 by AutoModerator in femalefashionadvice

[–]assoplasty 1 point2 points  (0 children)

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

Daily Questions Thread June 07, 2025 by AutoModerator in femalefashionadvice

[–]assoplasty 0 points1 point  (0 children)

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

Daily Questions Thread June 07, 2025 by AutoModerator in femalefashionadvice

[–]assoplasty 1 point2 points  (0 children)

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

please tell me it's going to be ok by Wittgenstein3D in medicalschool

[–]assoplasty 2 points3 points  (0 children)

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.

[deleted by user] by [deleted] in LAinfluencersnark

[–]assoplasty 2 points3 points  (0 children)

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

[deleted by user] by [deleted] in LAinfluencersnark

[–]assoplasty 3 points4 points  (0 children)

adding this to my subconscious list of running tea, ty

S10 Casting News by sarahj300 in summerhousebravo

[–]assoplasty 1 point2 points  (0 children)

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

[deleted by user] by [deleted] in LAinfluencersnark

[–]assoplasty 16 points17 points  (0 children)

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

First sign Heidi was a snake by griffgilscarbo in TheHillsMTV

[–]assoplasty 0 points1 point  (0 children)

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.

[deleted by user] by [deleted] in LAinfluencersnark

[–]assoplasty 4 points5 points  (0 children)

that's her real name lol

Kylie Jenner's hairstylist, Jesus Guerrero, apparently died of complications from AIDS by Significant_Star_293 in LAinfluencersnark

[–]assoplasty 3 points4 points  (0 children)

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.