Data from Column to be displayed on row

[gloom52]

I created a sheet for each individual month in a year with a "remarks" column beside each date. I wish for the information inside this "remarks" column to be displayed on another sheet in the row form where everything is the same just that the dates and the remarks are all displayed in the row rather than in the column.

How do I go about doing that?

[zbor]

can you upload example?

[teylyn]

Hi,

several solutions are possible, depending on what you want.

For a one-off copy and paste, you can use Paste Special and tick the Transpose option.

For a dynamic solution, have a look at the TRANSPOSE() formula. You first select a range that is the correct number of rows and columns, then enter

=TRANSPOSE(Sheet1!A1:M5)

and hit CTRL-SHIFT-Enter to confirm. This is an array formula and has to be entered with CSE.

If you're not comfortable with the array formula, please post a small data sample that represents your layout and we can look at more alternatives.

cheers

[gloom52]

Heres the document. I tried to use the transpose formula but it did not worked. Maybe I used it wrongly cuz I couldnt get it to change the data from column to the row format

[zbor]

You could use transpose, wich I also thought to make with, but try index

Team%20Attendance(1).xls

REF error is there purposely so you can see boundaries of formula, but you can just delete them.