ExcelBanter - Reformat Row to Column

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Reformat Row to Column (https://www.excelbanter.com/excel-discussion-misc-queries/230752-reformat-row-column.html)

Fellow Wanderer

Reformat Row to Column

Is there an easy way to quickly change data that is in a row to a column or
vice versa?

Example:
Jan Feb Mar

convert to:
Jan
Feb
Mar

Fellow Wanderer

Reformat Row to Column

Just figured it out....thanks!

"Fellow Wanderer" wrote:

Is there an easy way to quickly change data that is in a row to a column or
vice versa?

Example:
Jan Feb Mar

convert to:
Jan
Feb
Mar

All times are GMT +1. The time now is 05:11 PM.