Transposing blocks of cells

I am far from being a power user, and could use some help.
I've created a sheet that is too wide. I now want to transpose it from being wide to being tall. I understand the copy-paste special-transpose function, but I have groups of information in 3 cells and I want to transpose the 3 cells as a unit.
Can I group the 3 cells in any way that will allow me to transpose them as groups?
Is there a way to merge the contents of the cells and then transpose them?

Thanks

There is a transpose function, but it is a bit tricky to use...

Select the block of cells where you want the transposed data to be,
type in =TRANSPOSE(A1:A3) where A1:A3 is replaced by the range you want,
Press Ctrl Shift Enter (rather than just Enter).

Note that the selected area MUST be the same width as the height of the range to be transposed and similarly for the height of the selected area and width of the range.

Best to try it out on a test sheet before you try to use it on your proper data.

Once you've get the hang of it you should be able to devise a combination of
TRANSPOSE with perhaps the OFFSET function....

good luck.

Mark.