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
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?
| Seq# | ID |
| 1 | ad |
| 2 | ad |
| 3 | ad |
| 1 | ba |
| 2 | ba |
| 1 | c3 |
| 2 | c3 |
| 3 | c3 |
| 4 | c3 |
__._,_.___
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