Setting up Tree Structure

Only error I see is the fact you put the data on sheet 4, yet his macro refers to sheet 1. If you are going to change the sheet the data is on, the macro needs to be changed.

Set wsData = Sheets("Sheet1")

Set wsData = Sheets("Sheet4")

Dulanic,

Sheet4 is the original source data Jerry created the macro for. Sheet1 is the full data minus the blanks, so is the proper location for the macro to run.