How do I convert some data in the row to columns?

I have an issue that I need to resolve.
I'm currently getting data in a row format, but I need to convert some of the data into columns, for importing into Access.
For example......

Item Description Jan 05 Feb 05 Mar 05 Apr 05 ...........
ABC123 Widget A 100 250 175 210 ............
XYZ123 Widget B 50 75 100 76 ............

To convert to........


Column1 Column2 Column3 Column4
Item Description Date Qty
ABC123 Widget A Jan 05 100
ABC123 Widget A Feb 05 250
ABC123 Widget A Mar 05 175
ABC123 Widget A Apr 05 210
: : : :
: : : :
XYZ123 Widget B Jan 05 50
XYZ123 Widget B Feb 05 75
XYZ123 Widget B Mar 05 100
XYZ123 Widget B Apr 05 76
: : : :
: : : :

All data is in individual cells.

Can anyone help?

Thanks.

Colin.

Originally Posted by Colin T

I have an issue that I need to resolve.
I'm currently getting data in a row format, but I need to convert some of the data into columns, for importing into Access.
For example......

Item Description Jan 05 Feb 05 Mar 05 Apr 05 ...........
ABC123 Widget A 100 250 175 210 ............
XYZ123 Widget B 50 75 100 76 ............

To convert to........


Column1 Column2 Column3 Column4
Item Description Date Qty
ABC123 Widget A Jan 05 100
ABC123 Widget A Feb 05 250
ABC123 Widget A Mar 05 175
ABC123 Widget A Apr 05 210
: : : :
: : : :
XYZ123 Widget B Jan 05 50
XYZ123 Widget B Feb 05 75
XYZ123 Widget B Mar 05 100
XYZ123 Widget B Apr 05 76
: : : :
: : : :

All data is in individual cells.

Can anyone help?

Thanks.

Colin.

Hi Colin

Highlight the data you want to copy from rows to columns and then Edit > Copy, click in the first cell (cannot be the same as the cells you have copied) where you want the columns and Edit > Paste Special and check the transpose box and clicjk OK

Hope this helps

Paul

Thanks for the response.

However, I need to find some way of automating the process, that will also duplicate the data in the first columns, in line with the data that is transposed from the row to the column.

Regards,

Colin.

Have worksheet 1 be the one where you paste in new data.
Worksheet 2 is where you reference cells on worksheet 1. It would be a
template of the form that you want to see.

"Colin T" wrote:

>
> Thanks for the response.
>
> However, I need to find some way of automating the process, that will
> also duplicate the data in the first columns, in line with the data
> that is transposed from the row to the column.
>
> Regards,
>
> Colin.
>
>
> --
> Colin T
> ------------------------------------------------------------------------
> Colin T's Profile: http://www.excelforum.com/member.php...o&userid=26294
> View this thread: http://www.excelforum.com/showthread...hreadid=395758
>
>

Colin:
I wrote the VBA code to perform your needed work.
Send me your e-mail address and I will send it
to you;
Jim May


"Colin T" <[email protected]> wrote in
message news:[email protected]...
>
> Thanks for the response.
>
> However, I need to find some way of automating the process, that will
> also duplicate the data in the first columns, in line with the data
> that is transposed from the row to the column.
>
> Regards,
>
> Colin.
>
>
> --
> Colin T
> ------------------------------------------------------------------------
> Colin T's Profile:
> http://www.excelforum.com/member.php...o&userid=26294
> View this thread: http://www.excelforum.com/showthread...hreadid=395758
>