ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Move (print) text column on a separate row (https://www.excelbanter.com/excel-discussion-misc-queries/224744-move-print-text-column-separate-row.html)

Zorro[_2_]

Move (print) text column on a separate row
 
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


All times are GMT +1. The time now is 12:08 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com