Question

what steps should be followed to reserve the data from the rows to column or vice versa........​

Answer 1

Answer:

here it is

Explanation:

Select the range of data you want to rearrange, including any row or column labels, and press Ctrl+C.

Note: Ensure that you copy the data to do this, since using the Cut command or Ctrl+X won’t work.

Choose a new location in the worksheet where you want to paste the transposed table, ensuring that there is plenty of room to paste your data. The new table that you paste there will entirely overwrite any data / formatting that’s already there.

Right-click over the top-left cell of where you want to paste the transposed table, then choose

After rotating the data successfully, you can delete the original table and the data in the new table will remain intact