Convert data from columns to rows without losing already stored data below?

Question

How do I convert values from a column into rows without losing data in existing rows below? For example, I have data in this format:

      A   |    B    | C      |
1 | Apples| Berries | Cakes  |
2 | Pies  | Crusts  | Nuts   |

I need the following:

     A.  
1| Apples  
2| Berries  
3| Cakes  

1| Pies  
2| Crusts  
3| Nuts

Answer 1

If you have space available to the right or below your data, select and copy the row data. Then select a cell in the available space and "right" click to get the context menu. Choose Transpose from the paste options.

Once you've converted it, delete the empty rows where the data was before.