Range Shifted to the Right

[ricafonyat]

Good afternoon !

My objective is to shift the values contained in cells E1:P1 to the right just below in line 2 according to the value in cell B1. In this example, it would be just one cell to the right.

Thanks in advance.

Pasta1
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q
1	Num. Of Cells to the right =>	1		Cancelled Deals = >	35	40	60	25	43	17	25	14	13	12	11	10
2				Cancelled Deals Shifted = >		35	40	60	25	43	17	25	14	13	12	11	10
3
Planilha1

 

[hagia_sofia]

Hello, something like this (in E2):

=HSTACK(IF(SEQUENCE(,B1),""),E1:P1)