Mirroring Cells 3x

[Isaacamosu]

So i already understand the function of mirroring cells into another sheet, but for what I need I need each cell from one sheet to be mirrored into another sheet but appear 3x in that column
so for example
Sheet 1: Sheet 2:
Apples Apples
Apples
Apples

 

[FormR]

Hi, do you mean something like this.

Sheey1:

Excel 2013/2016
	A
1	Apples
2	Apples
3	Apples
4	Bananas
5	Bananas
6	Bananas
7	Oranges
8	Oranges
9	Oranges
Sheet1

Cell Formulas
Range	Formula
A1	=INDEX(Sheet2!A:A,ROUNDUP(ROWS(A$1:A1)/3,0))

Sheet2:

Excel 2013/2016
	A
1	Apples
2	Bananas
3	Oranges
Sheet2

 

[Isaacamosu]

Yup I think thats perfect! If we call sheet 2 : Overview and Sheet 1: Internal Data Pull How would the formula look then?

 

[FormR]

sheet 2 : Overview

Hi, it would look like this:

=INDEX(Overview!A:A,ROUNDUP(ROWS(A$1:A1)/3,0))

 

[Isaacamosu]

It worked somewhat, but the cells from overview only appeared once while i need it to appear 3x

 

[Scott Huish]

Does your range not start at A1 or something because it works fine for me.

Excel 2010
	A
1	Apples
2	Bananas
3	Oranges
Overview

Excel 2010
	A
1	Apples
2	Apples
3	Apples
4	Bananas
5	Bananas
6	Bananas
7	Oranges
8	Oranges
9	Oranges
Sheet1

Cell Formulas
Range	Formula
A1	=INDEX(Overview!A:A,ROUNDUP(ROWS(A$1:A1)/3,0))
A2	=INDEX(Overview!A:A,ROUNDUP(ROWS(A$1:A2)/3,0))
A3	=INDEX(Overview!A:A,ROUNDUP(ROWS(A$1:A3)/3,0))
A4	=INDEX(Overview!A:A,ROUNDUP(ROWS(A$1:A4)/3,0))
A5	=INDEX(Overview!A:A,ROUNDUP(ROWS(A$1:A5)/3,0))
A6	=INDEX(Overview!A:A,ROUNDUP(ROWS(A$1:A6)/3,0))
A7	=INDEX(Overview!A:A,ROUNDUP(ROWS(A$1:A7)/3,0))
A8	=INDEX(Overview!A:A,ROUNDUP(ROWS(A$1:A8)/3,0))
A9	=INDEX(Overview!A:A,ROUNDUP(ROWS(A$1:A9)/3,0))