VBA Code that will find, copy and transpose

Hello,

I'm looking all around for a VBA code that will:

1 - Search down one column for the word "ADDRESS"
2 - Once "ADDRESS" is found, I need to copy that cell along with the two cells directly above it and transpose these cells' contents to the three columns to the right
3 - I need this action performed down the entire column, which contains about 18,000 instances of "ADDRESS"