Hi, pretty new excel user and I was looking for a way to view columns as rows and vice versa without transposing the whole sheet.

I've tried transposing to two different worksheets and then linking but that process was slow and fraught with errors.

Is there any way to do this easily?
Anyone have any suggestions for lookups on the Excel website or Help, I've run out of ideas to look up

Thanks