u/Boom_Gate_Lady

I have a about 300 rows of data in a spreadsheet, I want to select all the rows that contain a certain word and group them somehow or put them in a table.

When I control, select the rows manually and right click the option to create a table disappears.

There must be a way I can do this. Does anyone have any ideas?

For context, the list is property addresses and I want to group them by suburb.

SOLUTION FOUND

I clicked in cell 1A I clicked filter This produced a down arrow. I clicked the down arrow I chose text filter I chose contains I typed in the suburb name and clicked go.

This is all I did as a non-excel expert. I'm not sure what you're all banging on about.

There's something I'm absolutely dying to know from other Lupus* out there.

Both times I have been in major major flair I have felt kind of crap and struggling to drag myself around while the flare was mounting and then, after being treated aggressively with the medication, I became MUCH WORSE. I mean much worse. I go from still going to work, though feeling a bit crap and tired, to not being able to walk, barely able to look after myself, sometimes not even able to sit up in bed. Then months later, on the same levels of medication I become better.

The first time this confused the hell out of me. I assumed it must have been the medication because I was okay (ish) before the medication and absolutely terrible after I commenced the regime.

Then it happened a second time. I'm absolutely intrigued to know what goes on in the body. There seems to be something that happens with the high barrage of medication that makes the body completely Haywire.

And here's the kicker, as time passes, my medication has NOT DECREASED except for the prednisone. I'm still on exactly the same high doses of plaquenil and cell Cept but my health is pretty much back to where it used to be after 9 months.

This suggests it isn't the medication. Now I know I said the prednisone decreased however, when I'm well I can go on a high dose of prednisone, and yes, I won't sleep, but it doesn't incapacitate me in any the other way. Certainly not to the extent I need a wheelchair.

I probably need a scientist to answer what is going on in the body at a cellular level to cause this reaction.

It feels like when we try and turn the Queen Mary that is a Lupus flare, the body goes into a meltdown.