planetsair
New Member
- Joined
- Jan 19, 2012
- Messages
- 42
- Office Version
- 365
- 2019
- 2016
- Platform
- Windows
hello
I have data in columns (B, C & D) and I would like to combine it all into one column (F) but ignoring the blank cells (my actual table has 50 columns of 10 rows)
I have got this far (see pic below) with this formula
=OFFSET($B$3, MOD(ROW()-ROW($F$1),ROWS($B$3:$B$12)), TRUNC((ROW()-ROW($F$1))/ROWS($B$3:$B$12)),1,1)
but I dont know how to make it ignore the blank cells - can anyone help me please ?
cheers
I have data in columns (B, C & D) and I would like to combine it all into one column (F) but ignoring the blank cells (my actual table has 50 columns of 10 rows)
I have got this far (see pic below) with this formula
=OFFSET($B$3, MOD(ROW()-ROW($F$1),ROWS($B$3:$B$12)), TRUNC((ROW()-ROW($F$1))/ROWS($B$3:$B$12)),1,1)
but I dont know how to make it ignore the blank cells - can anyone help me please ?
cheers