Hello all,
I have a series of values with narratives (columns A & B) which I want to be able transpose into another sheet but ignoring NIL values as follows:
I'd like transpose the data to another sheet so it will appear on consecutive rows as follows:
John 235.78 Mike 0.00 Fred 0.00 Andy 167.98 Paul 0.00 Will 54.12
I'd like to use formulae rather than code if possible but I'm not sure if this is possible ....
John 235.78 Andy 167.98 Will 54.12
As always, any help given would be greatly appreciated, thank you!
Bookmarks