Group rows based on indention of string in a column

C

Chris123

I am looking for a macro VB code to automatically group rows.

Example values from column A:
Row1: Training
Row2: Phase 1A + 1B
Row3: Architecture Overview
Row4: Training relevant AC components
Row5: System Setup
Row6: Setup enviornments
Row7: DEV
Row8: QA
Row9: PROD

This would result into the following groups:
Row 3+4 grouped into row 2
Row 2 grouped into row1
Row 7 - 9 grouped into row 6
Row 6 grouped into row 5

Would greatly appreciate if somebody implemented the same requirement
already....

Thanks,
Chris
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

At each change in data concatenate text values in contiguous ranges 2
transforming data into a single format/file 9
Filtering 0
Find Copy Paste 1
Convert Cell w/ Manual Breaks into New Rows 4
How to get the row number of new value in a column??? 1
Is it possible to use filtering in a row and in a column 2
count a value in a date range based on a date in another workshee. 4

Top