repeat cells

How would I turn: A1 A2 A3 Into: A1 A2 A3 A1 A2 A3 as many times as I want into a different sheet?

I am struggling to create a simple loop that will allow me to repeat a cell value down a column for a number of my choosing. I want to turn this: A1 A2 A3 Into this ("2", for example): A1 A1 A2 A2 A3 A3 Anything helps! Thank you.

Hi All :), My input is like this . <tbody> Date ordernum Name 1/2/2019 A23423 Alex 1/2/2019 B54534 John 5/2/2019 E454 Joe 4/2/2019 C64354 Ruby </tbody> In this above excel sheet, i need to repeat the values in 1st and 2nd column until the occurrence...

Hi Guys, Silly one that i cannot figure out, How do I get cell values to repeat down a list of cells based on the value of the cell before? Example: Cell F2 has LINK10 and in cell G2 I enter a value TEST for example, I want that to then fill in TEST all the way down the list everytime...

I have an excel database of survey information that returns the 1st, 2nd, and 3rd lowest values using SMALL formula, but I applied an IF formula on the spreadsheet to return the statement that value is tied to. However, if the value is the same it returns the same statement twice, rather than...

Hi Guys, I want create a formula that will produce the following pattern automatically: A 1 1 2 1 3 2 4 2 5 3 6 3 7 4 8 4 9 1 10 1 11 2 12 2 13 3 14 3 15 4 16 4 Appreciate your help

Hi. I'm not sure this is possible but here goes. And thanks in advance for any insight, even if that insight is "you can't". I have a number of dynamically sized, named arrays that I want to repeat in a column. For instance, the baseline array might have four values in a column (representing 4...

Hi I have some data that i need to expand out / unstack in excel with either some VBA or a formula. The data looks like this, (But is variable so will change, the values and the height data) <tbody> Months From 1st Purchase Number of Customers 2nd Order 0 5 1 4 2 5 3 3 4 1 5 6...

Hi I do not know if this has been answered before but I am working on a critical project and need help. I have customer data with channel (online etc ) in one column and the customer id in next column for two years. What I want is a formula to calculate unique customers in first year who...

I have a table that looks like this. <tbody> DealerName DealerPhone DealerAddress DealerCity DealerState DealerZip DealerEmail BuildingName1 BuildingAddress1 BuildingCity1 BuildingState1 BuildingZip1 BuildingName2 BuildingAddress2 BuildingCity2 BuildingState2 BuildingZip2...