Populate expanded list based on compact data

[lukihnio]

Hi All,

Thank you for taking time to look over my excel challenge.
I have a compact data, which should be extended in a larger sheet. below are both charts. I have given first chart and I would like the second chart to be populated. Prefer formulas, but if it's VBA, that's fine as well.

Many thanks in advance

Dep <tbody> </tbody>	Emp ID <tbody> </tbody>
Management <tbody> </tbody>	10000002 <tbody> </tbody>
Management <tbody> </tbody>
Management <tbody> </tbody>
TV <tbody> </tbody>	10000004 <tbody> </tbody>
TV <tbody> </tbody>	10000006 <tbody> </tbody>
TV <tbody> </tbody>	10000008 <tbody> </tbody>
TV <tbody> </tbody>
TV <tbody> </tbody>
TV <tbody> </tbody>
TV <tbody> </tbody>	10000010 <tbody> </tbody>

<tbody>
</tbody>

Dep <tbody> </tbody>	Emp ID <tbody> </tbody>
Management <tbody> </tbody>	10000002 <tbody> </tbody>
Management <tbody> </tbody>
Management <tbody> </tbody>
Management <tbody> </tbody>
Management <tbody> </tbody>
Management <tbody> </tbody>
Management <tbody> </tbody>
Management <tbody> </tbody>
Management <tbody> </tbody>
Management <tbody> </tbody>
TV <tbody> </tbody>	10000004 <tbody> </tbody>
TV <tbody> </tbody>	10000006 <tbody> </tbody>
TV <tbody> </tbody>	10000008 <tbody> </tbody>
TV <tbody> </tbody>	10000010 <tbody> </tbody>
TV <tbody> </tbody>
TV <tbody> </tbody>
TV <tbody> </tbody>
TV <tbody> </tbody>
TV <tbody> </tbody>
TV <tbody> </tbody>

<tbody>
</tbody>

 

[lukihnio]

I just wanted to mention that I've posted the same question at the below link:


Populate organized expanded list based on compact data in Excel - Stack Overflow