I'm trying to rotate values in a sheet and then duplicate the first value in the row as a header. For example:
a | b | c | d
a | b ----- a | c ----- a | d
Is there any way to do this with just Google Sheets commands, or do I need to use a script?