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...
You can come close by creating a pivot table from the first two columns. Drag the Election date field to the column area and the RegistrantID to both the row area and the Values area.