I have an excel with two columns. Column A contains numbers and column B contains text data. Numbers are continuous like 1 2 3 with several blank cells between them as shown below. For example:
1 Text Text Text 2 Text Text Text 3 Text Text
I need to insert a blank row just above each of the numbers in column A.
Can anyone help me to set up an excel macro to insert a blank row just above the cell containing a number in column A.