ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Duplicate Row for data found in columns (https://www.excelbanter.com/excel-discussion-misc-queries/193124-duplicate-row-data-found-columns.html)

jc

Duplicate Row for data found in columns
 
I have a spreadsheet in which columns G thru K may or may not have data. I
need to duplicate the row (with data from A - F) and add the data from the
other columns into a new cell/column. So if data where found in G, H and K I
would have three rows instead of just one. I know that I can do this in
pivot but would like to avoid that if possible. Any ideas?


All times are GMT +1. The time now is 06:59 PM.

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