Forum Discussion
Solved
How to automate changing a table to a structured list and exclude blanks
My goal is to take a table with any # of rows but limited number of columns like this: And have it convert to this format with power query: etc it omits any value <1 and iterates o...
Hi,
I have unpivoted the numerical columns and filtered the nulls. Does this help you?
Hi,
I have unpivoted the numerical columns and filtered the nulls. Does this help you?
this is of great help, unpivoting never occured to me thank you.