M
Mark64
I have a single column of data located in Column A similar as follows:
"Column A" "Column B" "Column 3" "....."
Example1*
* data1
Example2*
* data2
Example3*
* data3
and so on. What I want to do is have a macro to move the contents as follows:
"Column A" "Column B" "Column 3" "....."
Example1* * 1
Example2* * 2
Example3* * 3
Then I want to delete the empty rows where the data used to be. Is this
possible?
Thanks
"Column A" "Column B" "Column 3" "....."
Example1*
* data1
Example2*
* data2
Example3*
* data3
and so on. What I want to do is have a macro to move the contents as follows:
"Column A" "Column B" "Column 3" "....."
Example1* * 1
Example2* * 2
Example3* * 3
Then I want to delete the empty rows where the data used to be. Is this
possible?
Thanks