Home > Back-end >  Transform a data table from column based data to list column headers by their unique table entries
Transform a data table from column based data to list column headers by their unique table entries

Time:06-15

googlesheet new user here. Am trying to wrangle to some data in the most efficient way possible. I have done this transformation already via a formula of lookups and if statements but have to believe there is a better way with a query function or similar? any guidance would be greatly appreciated. The image shows the transformation required - would also be grateful if you could suggest how this question could be better worded. Thank you.

enter image description here

  • Related