Non Blank Values from a row

[subatomic]

Hi,

I have been working on doing this for many hours and have gotten as far as i can. driving me crazy now so any help is much appreciated.

i have a set of data that look in part like this

CAFÉ	150G PAN	150G REC PAN	135G PAN	WSDR	GSDR	LTB	GFG	CB	300G CB	STurkRoll	TB	XLTB
Rock & Roll	2	11	21				4			6
Another Italian	3	12	22
Park st	4	13	23
Branches	5	14	24

<colgroup><col><col><col><col><col><col><col><col><col><col><col><col span="2"></colgroup><tbody>
</tbody>

i need to extract from it something that looks like this to another sheet.

Rock & Roll	150G PAN	150G REC PAN	135G PAN	GFG	CBS
	2	11	21	4	6
Another Italian	150G PAN	150G PAN REC	135G PAN
	3	12	22

<colgroup><col><col><col span="3"><col></colgroup><tbody>
</tbody>

i think i am close to the first formula


=IFERROR(INDEX('Cafe Table'!B2:BQ2,SMALL(IF(LEN('Cafe Table'!B2:BQ2)>0,COLUMN('Cafe Table'!B2:BQ2)-COLUMN('Cafe Table'!$B$2)),COLUMN('Cafe Table'!1:1)),1),"")

then CTRL-SHIFT-ENTER

any help is very appreciated

THANKS !

 

[subatomic]

Just to be clear, i need a formula to output row of the numbers with no blanks in between. then another formula to extract the name of the bread above the number.

many thanks again