convert an array into a single row

  • Thread starter Thread starter nilmic via AccessMonster.com
  • Start date Start date
N

nilmic via AccessMonster.com

I have an a rray and want to convert it to a single row. i.e.

1 a
1 b
1 c
1 d
1 e
1 f
2 a
2 b
2 c

and I need this to look like this:
1 a b c d e f
2 a b c

can somebody help me with some vba code??
thanks,
 
At least one reply in another news group where you asked the same question.
Please limit your questions to a single news group.
 
maybe something like:

for t = 1 to ubound(arr(0))
debug.print arr(t,0)
for tt=1 to ubound(arr(1))
debug.print arr(t,tt)
next
next
 
damiaan:

thanks for your suggestion but my request is how to traspose the data from
one table to another creating only one record per array.
 
Back
Top