Hey Evarybodies
So I’m trying to figure something out in excel that will effectively save me days of time, but I just can’t this seemingly simple thing to happen.
So I have a CONCATENATE merging two cells like so:
a1, b1, a1b1
a2, a2, a2b2
a3, b3, a3b3
Which is super great buuuut I need this to happen:
a1, b1, a1b1
a1b1
a2, b2, a2b2
a2b2
a3, b3, a3b3
a3,b3
See whahamsayin? I just need the Concatenated row to dublicate to a new cell below it with the same information. If I do the drag dealie with two cells it starts counting by twos so I miss every other record, so that doesn’t. And for the life of me I can’t figure out how to do just do the same thing into two columns and then merge them so each cell is on top of the same cell from the other one, so that there are twice as many cells.
Haaaylp?
