Changing columns to only one row

[soleimani1967]

How can I change many data on columns to only one row just like to below example?

I have below data on columns (A1 to A3, B1 to B3, C1 to C3, D1 to D3,.....):

1 4 7 10
2 5 8 11
3 6 9 12

I want to have above data only on one row as follows:

1 2 3 4 5 6 7 8 9 10 11 12

It is not possible to use Transpose formula.

Thanks in advance for your help.

I have also posted this question on below link but I have not still received any reply.

http://www.ozgrid.com/forum/showthread.php?t=202136

[AliGW]

Thank you for adding a link to your cross-post.

[jolivanes]

These might be a couple possibilities.
Check and change all references as required. Try on a copy of your workbook first.

Please Login or Register  to view this content.

Please Login or Register  to view this content.

[soledad]

Try this

Please Login or Register  to view this content.

Copy across to the right

[soleimani1967]

Many thanks to jolivanes and soledad. You as well as solve my problem.

[AliGW]

Thanks for the rep, but I think it might have been intended for someone else, since I did not offer any VBA.

[soleimani1967]

I checked VB codes. Both of them as well as work. Thanks a lot again.