In Google Sheets I'm trying to transpose a list of items in rows to display as columns. I am looking for a way to transpose the
Category field to act as a header row that extends over all the items of that category in the transposed copy.
(Though not absolutely necessary, if there's a way to use conditional formatting to have the background color change for each category that would also be a huge bonus).
Here's a demo image:
and a link of what I'm trying to do.
If at all possible I'd like to accomplish this without using scripts!