formula that pulls data from multiple cells and puts it in every 2 rows

Alright so far I have not found anything that works and is efficient. I have attached a spreadsheet and within that spreadsheet there are two tabs (Sheet1, Data). Sheet 1 will have a formula for every cell in column D and it will pull the data from the Data tab in cells F,C,B,D (In that order) and place that data in Column D. The formula that is currently in there does exactly what I need but when I drag the formula down it takes way to long to process, it says Calculating: (8 Processor(s)) and has even crashed my computer. I have 16GB RAM and an Intel 8-core Haswell Extreme Edition processor (the i7-5960X) so I don't need any upgrading. . The idea is that I am working with debits and credits and this data will be fed into an Oracle system and what I need is that formula to pull that specific data into two rows (Debit row, Credit Row) so D2 and D3. so basically the formula in sheet 1 cell D2 will concatenate the data in F2,C2,B2,D2 from the data tab and then I want to drag that formula down and have it place the exact same data (F2,C2,B2,D2) into sheet 1 cell D3 as well. and then if I drag the formula down to cells D4 and D5 it will have concatenated the data from F3,C3,B3,D3 from the data tab into those cells. I would continue to drag as this data sheet will be filled daily with new data and is usually around 60-100 rows of new data every time. Thanks for any help

I think you'll find that this formula in D2 will be more efficient:

=INDEX(Data!F:F,INT((ROWS($1:1)-1)/2)+2)&" "&INDEX(Data!C:C,INT((ROWS($1:1)-1)/2)+2)&" "&INDEX(Data!B:B,INT((ROWS($1:1)-1)/2)+2)&" "&INDEX(Data!D:D,INT((ROWS($1:1)-1)/2)+2)

Copy it down as far as you need to.

Hope this helps.

Pete

Pete,

This works beautifully! It achieves exactly what I need and does not try to kill my computer. Thank You!

This is why I love excel. I always learn something new. This works perfectly and I wasn't even aware I could do it this way. Thank you!

~Love this forum~