separate data in rows

  1. U

    VBA Group Row Based on Cell Critieria

    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...
  2. H

    Formula to separate number from given line of text data

    Hi All, I hope anyone can help me with below request... I have data with filed called description and which consists of unique PO number and this line item not standard data, every line item which inclusive of special character different different numbers along with PO number. Example Data...
  3. Z

    Separate data in columns to match a specific number of rows

    Had no Idea how to title this, so to start with if anyone has a better title please help me out. New to Mr.Excel and hoping someone knows what I'm attempting to do. I am trying separate a specific number of rows in multiple columns to match another set of data with a greater number of rows. So I...
  4. D

    Separating and condensing data from table

    Hi, Hopefully someone can help me with a problem I can't seem to get my head around. Here's an example sheet: http://i.imgur.com/QWnpSLM.png I type names into A2:A8 and use VLOOKUP to fill B2:B8 with codes from H2:H10, so far so good. But then I'd like to generate a table in D2:E8 which lists...
  5. G

    New row for comma-separated values

    Hi, A sample spreadsheet of what I have is provided below: <tbody> ID NUMBER CHEMICAL NAME HAZARD VALUE 1 chemical a carcinogen recognized 1 chemical a Respiratory, blood, kidney suspected 2 chemical b immunotoxic, carcinogen suspected 3 chemical c liver, carcinogen recognized 4...
  6. T

    Totaling different cell content when in a ROW

    <!--[if gte mso 9]><xml> <o:OfficeDocumentSettings> <o:AllowPNG/> </o:OfficeDocumentSettings> </xml><![endif]--><!--[if gte mso 9]><xml> <w:WordDocument> <w:View>Normal</w:View> <w:Zoom>0</w:Zoom> <w:TrackMoves/> <w:TrackFormatting/> <w:PunctuationKerning/>...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top