I don't know how to write code, so I'm hoping one of you intelligent people can help me out. I've been looking all around for a VBA code that will:

1 - Search down column A for the word "ADDRESS"
2 - Once "ADDRESS" is found, I need to copy that cell along with the two cells directly above it (therefore, copying three cells) 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". The amount of rows between these instances varies and sometimes these in-between rows contain data and other times they don't contain data.

Thanks for any help you can give me with this.