Looping a column of cells to each cell in another column

How would I insert a group of cells to a single cell value?

Ex. Let’s say I have a two columns of cells. I want the cells in column “A” to be duplicated so that the cell value of “A1” is adjacent to all of the values in column “B”.

A       B             A       B

12      9   —>   12      9

43      8            12      8

32      7            12      7

                       43      9

                       43      8

                       43      7

                       Etc….

PS. My end goal is to concatenate the column “A” cell with all values of column “B” so if there is a quicker way to do that, please let me know!

By: Sean

Leave a Reply

Your email address will not be published. Required fields are marked *