![]() |
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