Report without null value

Sir,
I am attaching a file herewith, which is a table i manually entered, and the cells are connected to another book which is hidden, what i wanted is i have to get a report one by one in the same manner what i have shown in the file,
ie. from cell A23 onwards. As per my intention in A25 should be GBP, B26 800 C27 512, in the next line A26 will be CNY ect ect

What should i do to get that way, hopefully waiting the assistance.
thanx and regards
nowfal