'how to add rows in excel according to cell value

how can I add rows in excel according to the cell value (as per example below).

https://i.stack.imgur.com/q8MQG.png

i want to add column D if column A contain 'WALK IN' and create a single row.

like this one.

https://i.stack.imgur.com/f0yCb.png

thank you in advance



Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source