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?

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?

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?

On Jan 24, 6:23 pm, Ashkan wrote:
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.

I'm not the OP here <g. The earlier comments to post sample data /
expected results were meant for JDV (the OP).
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---

Sorry. I select wrong.

"Max" wrote:

On Jan 24, 6:23 pm, Ashkan wrote:
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.

I'm not the OP here <g. The earlier comments to post sample data /
expected results were meant for JDV (the OP).
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---