#Get data "Sheet 1" to "Sheet 2" in excel ( Check in Image , Follow Condition )

[krunal123]

#Get data "Sheet 1" to "Sheet 2" in excel ( Check in Image , Sheet 1 many Spaces in there , So i Need "invoice Number list" on Sheet 2 (Auto Generated)

how to possible get data as a list format,


NOTE: SHEET 1 :
*** So many Space in there***

SHEET 2 :
***WE Need Invoice only in Sheet 1 To Sheet 2 on list format***

 

[steve the fish]

Try:

=IFERROR(INDEX($B$1:$B$1000,AGGREGATE(15,6,IF($B$1:$B$1000<>"",ROW($B$1:$B$1000)),ROWS($A$1:A1))),"")

Change range if required. Drag down until you get blank cells.