Hi,
I have a table like below in cells A1:G3 with values ranging from 0 and above
Exam 1 0 0 12 10 0 6
Exam 2 20 4 0 6 9 0
Exam 3 0 3 0 0 17 0
I want to use a formula underneath this table to only extract the non-zero values in each row and turn it into this:
Exam 1 12 10 6
Exam 2 20 4 6 9
Exam 3 3 17
Can anyone help? I've attached a screenshot too to show how it would look.
Thanks!
Bookmarks