Hi Max
I think your can use Pivot Table Report ( in Data menu ). if it's not good,
tell me more and we hope can help you.

"Max" wrote:

Perhaps you could post some sample data, and the expected results in
plain text in reply here

That would greatly boost your chances of getting good responses fairly
quickly ..
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
On Jan 24, 3:56 pm, JDV wrote:
I have an instrument output file in Excel format that contains data for
several hundred chemical compounds. Each compound is listed in column A and
associated data are contained in the following 4 rows across 5 columns; some
cells are null, some contain values, etc. but the output location is
consistent for each chemical. All names and data are formatted as text.

I would like to reorganize the data to contain one row per compound with the
chemical name in column A and associated data in columns B, C, etc. Order
doesn't matter but obviously must be consistent.

How can I do this with either worksheet functions or programming?