*Assistance with formula*


Gail Richner

I have data in spreadsheet 1 that consists of 8 columns and 2500 rows

The data is laid out as follows
Col A Col B Col C Col D Col E Col F Col G
Col H
Row 1 AL BF0050C Bigfoot 1000 800 200 Smithfield 200
Row 2 VA CS0027F Smith 200 120 80 Austin 215
Row 3 GA HN4237D Maximum 1000 750 250 Smithfield

I am trying to pull the information into a spreadsheet consisting of 4
Col A Col B Col C Col D
Row 1 3/31/08 =H1&"-4005-"&A1 -D1 =B1&" - "&C1
Row 2 3/31/08 =H1&"-5360-"&A1 E1 =B1&" - "&C1
Row 3 3/31/08 =H2&"-4005-"&A2 -D1 =B2&" - "&C2
Row 4 3/31/08 =H2&"-5360-"&A2 E1 =B2&" - "&C2
Row 5 3/31/08 =H3&"-4005-"&A3 -D1 =B3&" - "&C3
Row 6 3/31/08 =H3&"-5360-"&A3 E1 =B3&" - "&C3

I need to have 2 rows per line of the original data and need to be able to
create for various number of rows

Any ideas on how to automate or copy or use fill to get every other row to
look at the next row in my data spreadsheet?

Thanks in advance for any assistance!

Gord Dibben

Attaching files is frowned upon in these news groups.

I would think someone from Microsoft Online Community Support should be aware of

Post files to an internet file-hosting site and leave the URL for interested
parties to download from there.

Gord Dibben MS Excel MVP

Jialiang Ge [MSFT]

Thanks Gord, I will take care of it in future.

Jialiang Ge ([email protected], remove 'online.')
Microsoft Online Community Support

Delighting our customers is our #1 priority. We welcome your comments and
suggestions about how we can improve the support we provide to you. Please
feel free to let my manager know what you think of the level of service
provided. You can send feedback directly to my manager at:
(e-mail address removed).

This posting is provided "AS IS" with no warranties, and confers no rights.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question