Is it possible to paste data from one excel sheet into every 2nd Row in another??

[Sineadd]

Hi

I have data in a table like below in one excel sheet

	Week 1	Week 2	Week 3	Week 4	Week 5	Week 6	Week 7	Week 8
2020​	500​	100​	5000​	1000​	2000​	5000​	5000​	4500​

I want to copy the above data and paste into a table like table below but I need it to paste into every 2nd column like below as this is how I have been asked to display the data

Week 1

% Overall

Week 2

% Overall

Week 3

% Overall

Week 4

% Overall

Week 5

% Overall

Week 6

% Overall

Week 7

% Overall

Week 8

% Overall

2020​

500​

100​

5000​

1000​

2000​

5000​

5000​

4500​

Is this possible and if so can someone please point me in the right direction.



Thanks in advance
Sinead

 

[RAJESH NATH]

New Microsoft Excel Worksheet (3).xlsx
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P
1
2		Week 1	Week 2	Week 3	Week 4	Week 5	Week 6	Week 7	Week 8
3	2020	500	100	5000	1000	2000	5000	5000	4500
4
5		Week 1	% Overall	Week 2	% Overall	Week 3	% Overall	Week 4	% Overall	Week 5	% Overall	Week 6	% Overall	Week 7	% Overall	Week 8
6	2020	500		100		5000		1000		2000		5000		5000		4500
Sheet2

Cell Formulas
Range	Formula
B6,P6,N6,L6,J6,H6,F6,D6	B6	=INDEX($B$3:$I$3,MATCH(B5,$B$2:$I$2,0))

 

[Sineadd]

I have tried the above but just get #N/A in B6

With the Range references you have listed above do i need to put that somewhere??

Range	Formula
B6,P6,N6,L6,J6,H6,F6,D6

Thanks
Sinead

 

[Sineadd]

Apologies I had a typo in the cell headers so formula wasnt able to carry out the Match Function.

Working perfectly

Thanks so much for your help

 

[RAJESH NATH]

Apologies I had a typo in the cell headers so formula wasnt able to carry out the Match Function.

Working perfectly

Thanks so much for your help

Thank you for your feedback