ACCESS FEED: Re: [MS_AccessPros] Rows in columns

Jumat, 30 Januari 2015

Re: [MS_AccessPros] Rows in columns

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?