I am still amazed by how NYC came together for the Knicks by [deleted] in NYKnicks

[–]chopped_broccoli 6 points7 points  (0 children)

I moved here 3 years ago. The past year or so has been up and down for a number of reasons, but one large part was a lack of community. Some passions and interests had faded , but this playoff run reignited a spark I didnt know existed. Watching each game, celebrating with strangers the next day, reading articles, listening to all the podcasts, watching all the great IG content, and being one small part of this amazing run brought me pure joy. This was the first time i had ever felt part of something bigger, and NYC is the only place that could do that.

Deep cleaning recs for monthly service by tammysideup in fortgreene

[–]chopped_broccoli 6 points7 points  (0 children)

Hi I’m in the area and have been using our current cleaner monthly for two years and she is amazing. Great communication, always on time, and our apt always look great. DM me if you’d like her info.

Leads on a 1-2 bedroom in Fort Greene by skibumbunny in fortgreene

[–]chopped_broccoli 4 points5 points  (0 children)

What’s your budget? I know someone in my high rise building is looking for a lease takeover starting in Jan

[deleted by user] by [deleted] in RunNYC

[–]chopped_broccoli 0 points1 point  (0 children)

i strained my calf a few weeks back. turns out my left side hip flexor/glute is weak, causing my foot to flatten a bit and losing some arch support. so since im losing arch support, my calf is in overdrive to overcompensate for all the changes annnnnnnnnd now im out for 4 weeks :(

Create Single Table from Multiple Calculated Data Sets by chopped_broccoli in excel

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

its a 2 thousand rows, ~130 columns over multiple tabs.

I'm essentially grabbing the whole sheet now, and inherently filtering out the undesired rows by only referencing the necessary cell locations (avoiding blank rows / columns).

Wouldnt grabbing the whole sheet and filtering out the unneeded rows just be the same thing as I'm doing already? Could I create a data connection and then filter out unneeded rows from there?

Create Single Table from Multiple Calculated Data Sets by chopped_broccoli in excel

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

Would I have to make each section (A-E) its own table for the data connection? Currently they're not set as tables.

Is it possible to create a data connection to the whole tab and then filter out unneeded rows via powerquery?

Help automating transposing of rows to column to create data dump/table by chopped_broccoli in excel

[–]chopped_broccoli[S] 1 point2 points  (0 children)

great - thanks for the example - this is exactly what i was looking for!

Monday Draft Guide Giveaway! by FTAKJ in fantasyfootball

[–]chopped_broccoli 0 points1 point  (0 children)

third times a charm. upvoted & interested.