Share via

Cut & Paste {Column to Row}

Anonymous
2021-08-13T17:33:34+00:00

I am attempting to cut cells from A7:A9 to A6:C6 in the attached spreadsheet. Is it possible for me to do this? If it is possible, how can I do it?

https://1drv.ms/x/s!AnD1c3knABvcxnHcKQ_TJPtZ6OT0?e=EnOGiW

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

Answer accepted by question author

HansV 462.6K Reputation points
2021-08-13T17:49:12+00:00

Youcan't cut and paste transposed in one step. You'll have to do this in two steps:

  1. Copy and paste transposed
  • Select A7:A9.
  • Copy the selection (Ctrl+C).
  • Select A6.
  • Click the lower half of the Paste button and select Transpose.

  1. Clear the original data
  • Select A7:A9 again.
  • Press Delete.

Was this answer helpful?

1 person found this answer helpful.
0 comments

1 additional answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2021-08-14T21:39:05+00:00

    Thank you for the advice. Solves my issue.

    Was this answer helpful?

    0 comments