Move cell data to another column so each column has the same data values

[MarkH]

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 ColN data is ordered alphbetically by the values. ie col1=p, col2=q, col3=r  etc....

Computer Col1 Col2 Col3  ........many more columns

A                null   q      r

B                  p    null   r

Any suggestions please.

[ppm1]

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

[MarkH]

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)