Hi Tom In excel if you can transpose the data that would be an easy solution. If you are working with an array and can't or dont want to transpose the data for some reason, you can work with filter array or delete rows. a,b,c,d 1,2,34 a,b,g,r w,x,y,z A simple way is to work with your html table with one row and 4 columns so 4 cells. Prior to the table html, create four arrays array_1, array_2. Use the dalete rows metatag so each array is just one row. (a,b,c,d) Then in each cell of your table loop down the correct array, then move to the next cell. To avoid hard coding the name of the array you can use caculations name= array_(numrows-(numrows-rowindex)), this would be array_(4-(4-1)) or array_1 and this would be used in row 1, cell 1.
If your data doesnt line up correctly and you want to have 4 rows and 4 columns you can still do this but you have to use filters for each cell. I do a lot of this to make complicated excel type data tables using just witango and html. I mean I dont use any third party tool for making data tables or charts. So Tom you might also look at some of the 'chart' tools for witango, I have no idea if they can do want you want but they might. Hope this helps Janet -----Original Message----- From: Wayne Irvine [mailto:[EMAIL PROTECTED] Sent: Sunday, December 17, 2006 5:03 PM To: [email protected] Subject: Re: Witango-Talk: OT: Simple Task, but not if you're a simpleton... like me Tom Ferguson at [EMAIL PROTECTED] wrote: > I want the first row to go to to column 1, second row to go to column 2, > third row to go to column 3, fourth row to go to column 4, and a new record > is created. Select the data, Copy, Paste Special:Transpose. W Byte Services Pty Ltd http://www.byteserve.com.au/ [EMAIL PROTECTED] Ph 02 9960 6099 Mob 0409 960 609 Fax 02 9960 6088 ________________________________________________________________________ TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf ________________________________________________________________________ TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
