Jumat, 30 Januari 2015

Re: [MS_AccessPros] Rows in columns

 

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
IDPanelDescription
adredrandom text
adyellowrandom text
adbluerandom text
baorangerandom text
bablackrandom text
c3grayrandom text
c3whiterandom text
c3purplerandom text
c3greenrandom text

and I want to convert it to 
IDPanel 1DSCR 1Panel 2DSCR 2Panel 3DSCR 3Panel 4DSCR 4
adredrandom textyellowrandom textbluerandom text  
baorangerandom textblackrandom text random text  
c3grayrandom textwhiterandom textpurplerandom textgreenrandom 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?
Seq#ID
1ad
2ad
3ad
1ba
2ba
1c3
2c3
3c3
4c3








__._,_.___

Posted by: Crystal <strive4peace2008@yahoo.com>
Reply via web post Reply to sender Reply to group Start a New Topic Messages in this topic (3)

.

__,_._,___

Tidak ada komentar:

Posting Komentar