Sheet1 contains the data
<tbody>
</tbody>
What I would like on sheet2 is
Row 1 = 1 merged Column with Department Value Centered
Row 2 = Column 1 Position, Column 2 Name, Column 3 Extension
Repeat while Department Value is the same, when the Department Value changes Merge the Column and insert new Department Name, Next row start adding again
Is that even possible?
Department | Position | Name | Extension |
<tbody>
</tbody>
What I would like on sheet2 is
Row 1 = 1 merged Column with Department Value Centered
Row 2 = Column 1 Position, Column 2 Name, Column 3 Extension
Repeat while Department Value is the same, when the Department Value changes Merge the Column and insert new Department Name, Next row start adding again
Is that even possible?