Forum Discussion
Convert list of data to table
Hello everyone, I have a data set of this form: Author Author1 Title Title1 Date Date1 Author Author2 Title Title2 Date Date2 Author Author3 Title Title3 Date ...
You may do that with Power Query
- add Index
Integer-divide on 3
Pivot Column2 with All rows of Column3 in aggregation