Transpose of cell

[lalaarif1]

Dear Friends,

I am attaching the file for your reference.

I would to transpose the date.
Data is in column A.
Output required is in col C.

Please assist since the database involved is huge.

[MickG]

Try this:-

Please Login or Register  to view this content.

Regards Mick

[lalaarif1]

Wow...

Thanks a lot...

Its working fine...

2 question.

In the end, cells remain copied. Can we put "Esc" command in macro and select Cell A2".
And
Is it possible to have the option of selecting the cell from where the Transpose macro should start.?

Rest all good.

[junmacs]

you can select range to transpose and copy, in paste option you will see the transpose icon.