Data in the cell to be displayed next to each other

[goodboy]

HI,
Attaching a excel sheet
row 1 contain heading
row 2 contain data
row 3 contain data and so on for row 4, row 5

row 2 have some cells that have data eg from B2 to AA2 there are two cells that have data now i want these data to display next to each other in cells AC2 onwards

row 3 may have cells that have 7 data so these data needs to be displayed from AC2 to AI7

Hope this clear

Thanks in Advance

[Special-K]

in AC2
=IFERROR(INDEX($B2:$AA2,1,AGGREGATE(15,6,COLUMN($B2:$AA2)/(($B2:$AA2<>0))-1,COLUMNS($B1:B1))),"")
copy across as far and down as BB3

[goodboy]

Thanks a lot