Forum Discussion
Move 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 ...
The 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
Please 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)