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

Question

I have the following.&nbsp;Computer Col1 Col2 Col3&nbsp; ........many more columnsA&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;r&nbsp; &nbsp; &nbsp; &nbsp;q&nbsp; &nbsp;null&nbsp; &nbsp; &nbsp;&nbsp;B&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; null&nbsp; &nbsp; p&nbsp; &nbsp; &nbsp;r&nbsp; &nbsp; &nbsp; &nbsp;&nbsp;&nbsp;I need the following result where the ColN data is ordered alphbetically by the values. ie col1=p, col2=q, col3=r&nbsp; etc....&nbsp;Computer Col1 Col2 Col3&nbsp; ........many more columnsA&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; null&nbsp; &nbsp;q&nbsp; &nbsp; &nbsp; rB&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; p&nbsp; &nbsp; null&nbsp; &nbsp;r&nbsp;Any suggestions please.

ppm1 · Answer

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 · Answer

Please see pbix :&nbsp;https://drive.google.com/file/d/1ol1xxWHH0Q6ay76DSrv4abOgzc60ZjYL/view?usp=sharingSource Data &amp; Required Outcome are providedI have made 1 attempt in Source Data (2)

Forum Discussion

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

2 Replies

Related content

Sort by another column

Find Most Recent Date Relative to another Date Column in Power Query

Calculate new column based on another column's text

New Column

[PowerQuery] add (same) column from another table