Is there a macro I can copy to accomplish the following please?
Suppose this is in column A:
1> James Anderson
2> Jan 12, 1873
3> Aug 10, 1944
4> “Devoted Father”
5> William Brown
6> Feb 17, 1900
7> Jul 22, 1982
And so on…….
Ok, I highlight the first four options. Is there an easy macro to change
that to:
A
B C
D
1 James Anderson Jan 12, 1873 Aug 10, 1944
“Devoted Father”
I.e., whatever I highlight is spread across ONE row? Right now, I tried a
macro, but it pastes in the wrong cell. Automating this would save about
nine days work. After I highlight the next three rows, it gets spread out
like this:
A
B C
D
5 William Brown Feb 17,1900
Jul 22, 1982
???
I can do a sort later and remove the empty rows. Possible?