copy data from vertical position to horiziontal position

[mojo.935]

I am getting data that looks like the following

54618ET00A 6000 06/28/2012
54618ET00A 7200 06/29/2012
54618ET00A 4800 06/30/2012

But I would like to see it this way
54618ET00A 06/28/2012 6/29/2012 6/30/2012
6000 7200 4800


Is this possible? Thanks.

[dmang1]

Hello,

Yes there are a couple of ways to do this:
1. The easiest is to Copy the data and use the Paste Special>Transpose feature, or
2. Use the TRANSPOSE function.

If this solves your issue, mark the thread as solved.

Cheers,
Diana