How to get list while ignoring blank cells

[mangocat123]

I have a table (sample) which tells me which are the dates that has the items and quantity.

Is there a formula where I can ignore the blank cells and create a list of the dates?

This is what I hope to achieve

Wouldn't want to use filter or sort option as the dates can be very far back.

Thank you for your help! ☺

 

[Cubist]

Try:

Book1
	A	B	C	D	E	F	G	H	I	J	K	L	M
1	Item	1/1/24	1/2/24	1/3/24	1/4/24	1/5/24	1/6/24	1/7/24	1/8/24	1/9/24	1/10/24	1/11/24	1/12/24
2	A			1			5				1
3	B				2		2				2
4	C						5				2
5
6	Dates have item
7	1/3/24
8	1/4/24
9	1/6/24
10	1/10/24
Sheet1

Cell Formulas
Range	Formula
C1:M1	C1	=B1+1
A7:A10	A7	=SORT(UNIQUE(TOCOL(IFS(B2:M4<>"",B1:M1),2)))
Dynamic array formulas.

 

[mangocat123]

Try:

Book1
	A	B	C	D	E	F	G	H	I	J	K	L	M
1	Item	1/1/24	1/2/24	1/3/24	1/4/24	1/5/24	1/6/24	1/7/24	1/8/24	1/9/24	1/10/24	1/11/24	1/12/24
2	A			1			5				1
3	B				2		2				2
4	C						5				2
5
6	Dates have item
7	1/3/24
8	1/4/24
9	1/6/24
10	1/10/24
Sheet1

Cell Formulas
Range	Formula
C1:M1	C1	=B1+1
A7:A10	A7	=SORT(UNIQUE(TOCOL(IFS(B2:M4<>"",B1:M1),2)))
Dynamic array formulas.

the formula works perfectly! thank you so much