group by rows

Hello, I have a large spreadsheet which contains several groups of observations as individual rows. For example, there is an "obs" column with ten rows having an observation value of "1", six rows having an observation value of "2", eight rows having an observation value of "3", and so on. For...

Hello Guys, I have below data that I need to group based on criteria below: Raw (Sheet1): <tbody> ID Name Status 01 Donna Done 05 Karl Complete 06 Ems Pending 02 Shawn Incomplete 05 Mae 03 Ann OK </tbody> End Result: <tbody> ID Name Status 01 Donna Done 03 Ann OK 05...

Hi There, I wonder if someone can help me? I have a series of data (~700 rows, 5 columns) that I am looking to allocate into 5 groups using a random function and based on a series of rules / criteria that I would like to apply. I wondering if there is a simple formula that I can apply to the...

Hi all, I have a quick question about performing "group by" in excel. I currently have to 2 columns named, "name"' and "number" as shown below. Name Number Balance 2000 Balance 300 Balance 200 Sales Deduction 20 Sales Deduction 30 ROI 20 ROI 10 Balance 29 Sales Deduction 1000 ROI 90 Sales...