Hi all,
im sorry to ask something which may seem simple, however I was hoping someone may be able to help me with the automation of a tedious task?
I have a spread sheet of assets and I would like to insert 3 items that relate to each asset below.
for example.
Col A
Tank 1
Tank 2
Tank 3
Tank 4
I would like to insert additional items that are associated to each tank.
Cover, Valve, Feed line, Hose
so my list would then look like:
Tank 1
Tank 1 Hose
Tank 1 Feed Line
Tank 1 Valve
Tank 1 Cover
Tank 2
Tank 2 Hose
Tank 2 Feed Line
Tank 2 Valve
Tank 2 Cover
etc...
Is there anyone who can help me with this?
I have over 600 tanks :-(
Bookmarks