Move (print) text column on a separate row

Z

Zorro

Assume 1st name is column A, and the comments are column D

(row 1) John | Smith | 4155551212 | Very good client, always pays on time
(row 2) Bill | Adams| 2125551212 | Do not call this client before 10:00AM

Can I insert or move the comments (column D) on to a separate row,
immediately below the original row? Result would look like this:

(row 1) John | Smith | 4155551212
Very good Client, always pays on time
(row 2) Bill | Adams| 2125551212
Do not call this client before 10:00AM

Or it would also be okay if it was like this:

(row 1) John | Smith | 4155551212
(row 2) Very good Client, always pays on time
(row 3) Bill | Adams| 2125551212
(row 4) Do not call this client before 10:00AM
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Automation of scanned file storage based on content 0
How can I print rows that go outside of the page without shrinking the text? 0
calculate time does not calculate 4
Macro help?: move row to other sheet when text is entered in cell 0
Colour Coding dates 6
move a row of data values to a column in sorted order 2
Find a time value in one column based on names in another 1
How do I insert a row or rows between each row of text and copy the row above? 0

Top