Hi there,
Can anybody help me to aggregate column data in a row to fill blanks?
I need a formula only.
Suppose I have...
Col 1 Col 2 Col 3 col 4 col 5
123 blanks 456 blanks 789
33 44 blanks 55 66
I want ....
Col 1 Col 2 Col 3 col 4 col 5
123 456 789 blanks blanks
33 44 55 66 blanks
Any help will be appreciated.
Thank you
Bookmarks