J
JC
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?
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?