Osvaldo Palmeiro
Well-known Member
- Joined
- Feb 24, 2009
- Messages
- 753
- Office Version
- 365
- Platform
- Windows
Hi all.
I would like to have a formula to replicate data from one row to one column skiping blanks.
So I have in range A1:E1 ~~~> | apple | blank | pear | blank | orange |
And I'm looking for a result like:
B3 = apple
B4 = pear
B5 = orange
Many thanks in advance
I would like to have a formula to replicate data from one row to one column skiping blanks.
So I have in range A1:E1 ~~~> | apple | blank | pear | blank | orange |
And I'm looking for a result like:
B3 = apple
B4 = pear
B5 = orange
Many thanks in advance