Forum Discussion
MarkH
Helper I
Helper IMove cell data to another column so each column has the same data values
I have the following. Computer Col1 Col2 Col3 ........many more columns A r q null B null p r I need the following result where ...
ppm1
Solution Sage
Solution SageThe solution will likely involve list and record functions (e.g., Record.ToList, List.Sort). Can you post some more example data and explain the logic for how null values should be handled?
Pat
MarkHHelper I
Helper IPlease see pbix : https://drive.google.com/file/d/1ol1xxWHH0Q6ay76DSrv4abOgzc60ZjYL/view?usp=sharing
Source Data & Required Outcome are provided
I have made 1 attempt in Source Data (2)