flatten

  1. A

    Convert Parent-Child into Excel Hierarchy using VBA

    Hi experts! I'm trying to traverse and convert a Parent|Child file into a separate hierarchy, with a header. The 'depth' of the Parent|Child relationships is yet unknown, so the output could stretch to many columns on the right. I have tried coding for just two input columns, with little...
  2. H

    Hierarchical data combined into list for Google Sheets

    Good day. I have a sheet of data, columns D:G Column D is the "parent" of E, E is the parent of F and F is the parent of G. example data below: Column D Column E Column F Column G Bedroom 1 Building Internal Partitions Framework Bedroom 1 Building Internal Partitions...
  3. Q

    Flatten Rows in a Table for a Listbox

    Hello everyone! I have been trying to find a way to do this for a while now and I can't come up with anything good. As always, any help pointing me on the right path would be greatly appreciated. What I need to do is to flatten multiple rows into one row, keeping non-empty cells in specific...
  4. H

    How to flatten SELECTED worksheets in my Excel file.

    I hope someone can help me. I need the code on how to flatten SELECTED worksheets (not all) in my Excel file. I have more than 150 worksheets to flatten and the number of worksheets that need to be flattened will vary according to the data entered on the first worksheet. I do not know how to...
  5. A

    flatten structured data to list

    I have a report of liquor license owners where each record takes 8 rows and 6 columns. Each data element has a tag in the cell immediately to the left of the data. all records appear to be structured the same: 3 rows, a blank row, 3 rows, two blank rows between records. How can I flatten this...

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