Let's say:
Your header in Sheet1 row 1
and your data in A2 to A100

In sheet2:
A2 for date
=IF(ISERR(SMALL(IF(Sheet1!$E$2:$E$100=3,ROW(INDIRE CT("1:"&ROWS(Sheet1!$E$2:$E$100)))),ROWS($1:1)))," ",INDEX(Sheet1!$A$2:$A$100,SMALL(IF(Sheet1!$E$2:$E $100=3,ROW(INDIRECT("1:"&ROWS(Sheet1!$E$2:$E$100)) )),ROWS($1:1))))
ctrl+shift+enter (not just enter)

B2 for Item
=IF(ISERR(SMALL(IF(Sheet1!$E$2:$E$100=3,ROW(INDIRE CT("1:"&ROWS(Sheet1!$E$2:$E$100)))),ROWS($1:1)))," ",INDEX(Sheet1!$C$2:$C$100,SMALL(IF(Sheet1!$E$2:$E $100=3,ROW(INDIRECT("1:"&ROWS(Sheet1!$E$2:$E$100)) )),ROWS($1:1))))
ctrl+shift+enter (not just enter)

C2 for Amount
=IF(ISERR(SMALL(IF(Sheet1!$E$2:$E$100=3,ROW(INDIRE CT("1:"&ROWS(Sheet1!$E$2:$E$100)))),ROWS($1:1)))," ",INDEX(Sheet1!$D$2:$D$100,SMALL(IF(Sheet1!$E$2:$E $100=3,ROW(INDIRECT("1:"&ROWS(Sheet1!$E$2:$E$100)) )),ROWS($1:1))))
ctrl+shift+enter (not just enter)
Select range from A2:C2 then copy down as far as needed






"Lynn" wrote:

I want some scattered rows of data that are uniquely identified by a number
(example 3), in a cell in their row. Using an IF function, I want to move
the data to another page, then have it all move up to fill the first open
row. Is this possible. I know how to get the IF part done. But not the
close up the spaces part. For example

Journal entry page
date vendor item amount code

11/30 progress elec 75 .00 3
12/1 taylors supplies 32.90 2
12/29 progress elec 44.00 3


Progress account page (this is how it brings it now, with a space)

Date Item Amt
11/30 elec 75.00
I want to eliminate this space and have the data move up automatically.
12/29 elec 44.00

Is this possible?