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

[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.

 

[Paul Sheppard]

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

Item Description Jan 05 Feb 05 Mar 05 Apr 0
...........
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 Edi

Copy, click in the first cell (cannot be the same as the cells yo

have copied) where you want the columns and Edit > Paste Special an
check the transpose box and clicjk OK

Hope this helps

Pau

 

[Colin T]

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.

 

[Guest]

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.

 

[Jim May]

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