Copy Multiple Skip Blanks

Please mock up what you expect as a result. It is not at all clear what you are wanting.

Hi,

It's not clear (at least to me) precisely what you want. I'm guessing, maybe incorrectly that you are looking to shift cells left in some way but that is a guess.
Please clarify and upload a workbook with examples of real data (not just example a,b,c type data). In addition manually add the layout and results you expect to see when the task is finished.

This is just a quick guess.

It is an array-entered formula. If you aren’t familiar with array-entered formulas array enter means the formula must be committed from edit mode by simultaneously pressing and holding down Ctrl and Shift while hitting Enter. You don't type those curly braces {} in yourself. It won't work if you do. Excel does it for you.

Row\Col	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R
1		Array-entered in D4, filled down and copied to columns I and N : {=INDEX(E4:H4,MATCH(1,--ISNUMBER(E4:H4),0))}
2		1	2	3	4	5	1	2	3	4	5	1	2	3	4	5
3	a	1					3		3			2	2
4	b	2	2				5				5	4			4
5	c	3		3			4			4		3		3
6	d	4			4		3		3			5				5
7	e	5				5	2	2				2	2