Forum Discussion
Transpose some rows to columns, then merge rows
How do I go about transforming the table on the left to the table on the right? I have 600,000 rows to do: RegistrantID ElectionDate 11/8/2022 11/3/2020 11/6/2018 11/8/20...
An alternative could be Power Query. In the attached file you can add data to the blue dynamic table. Then you can click in any cell of the green table and right-click with the mouse and select refresh to update the green result table.