Hello there, Here's my query I have a Spreadsheet table with entries per month that I want to turn into a list that updates with new information as it is entered - this far I have been able to get BUT I don't want to see the nil or Zero entries in my list as it makes it too bulky see example below (as I'd like to see it working new entry in red):
Spreadsheet
Jan Feb Mar Apr
A 1 11 20 31
B 2 21 32
C 12 22
D 3 13 33
List
Jan
A 1
B 2
D 3
Feb
A 11
C 12
D 13
Mar
B 21
C 22
Apr
A 31
B 32
D 33
New Entry For March updates to:
Mar
A 20
B 21
C 22
I have tried a filter but this doesn't update?
Am I missing something or is there an elegant solution??
Many thanks in advance
Marktwo
Spreadsheet
Jan Feb Mar Apr
A 1 11 20 31
B 2 21 32
C 12 22
D 3 13 33
List
Jan
A 1
B 2
D 3
Feb
A 11
C 12
D 13
Mar
B 21
C 22
Apr
A 31
B 32
D 33
New Entry For March updates to:
Mar
A 20
B 21
C 22
I have tried a filter but this doesn't update?
Am I missing something or is there an elegant solution??
Many thanks in advance
Marktwo