flatten

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

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

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

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

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