ACCESS FEED: Re: [MS_AccessPros] Rows in columns

Jumat, 30 Januari 2015

Re: [MS_AccessPros] Rows in columns

oh! ... and one more thing ... Paste SPECIAL

then you can copy and paste back into Access ... when you paste into the Navigation Pane, Access will create a table for you

(then of course, you will want to go into the Design View and modify Data Types and Sizes of the fields)

Warm Regards,

Crystal

New! Free tool to make Caption Files (SRT) for videos (written in Microsoft Access)
https://www.youtube.com/watch?v=xhoLAWJIRnA

~ have an awesome day ~

On Friday, January 30, 2015 5:45 PM, Crystal <strive4peace2008@yahoo.com> wrote:

oops!

paste datA

~Crystal

On Friday, January 30, 2015 5:44 PM, Crystal <strive4peace2008@yahoo.com> wrote:

You can do this very easy with Excel ...

paste date in, select it, copy it, then go to some blank cells, right-click, choose Paste --> Transpose

Warm Regards,

Crystal

Free tool to make Caption Files (SRT) for videos (written in Microsoft Access)
How To Make Video Captions, Free Microsoft Access Tool (cc) - Subtitle YouTube (and more!) Videos

~ have an awesome day ~

On Friday, January 30, 2015 4:14 PM, "fguasp@snet.net [MS_Access_Professionals]" <MS_Access_Professionals@yahoogroups.com> wrote:

Is there an better/easier way to convert rows into columns?

I have the following data

ID	Panel	Description
ad	red	random text
ad	yellow	random text
ad	blue	random text
ba	orange	random text
ba	black	random text
c3	gray	random text
c3	white	random text
c3	purple	random text
c3	green	random text

and I want to convert it to

ID	Panel 1	DSCR 1	Panel 2	DSCR 2	Panel 3	DSCR 3	Panel 4	DSCR 4
ad	red	random text	yellow	random text	blue	random text
ba	orange	random text	black	random text		random text
c3	gray	random text	white	random text	purple	random text	green	random text

I put a sequential number for each item in that group and I am going to do it in with a nested loop where each sequential # points to a field group... Is there a better way?