Re: Concatenate Column Values from Multiple Rows into a Single Column (1 Viewer)

Re: Concatenate Column Values from Multiple Rows into a Single Column

I have a similar problem but need a silghtly different output...

ID Field1 Field2 Field3
1 Bob House 2010
2 Bob Car 2010
3 Bob Work 2010
4 Bob Wife 2010
5 Joe Work 2011
6 Joe School 2011
7 Joe Car 2011

I would like it to be...

ID Field1 Field2 Field3
1 Bob House 2010
Car
Work
Wife
2 Joe Work 2011
School
Car
I have marco in Execl that will do this but I have to break the file up over multiple tabs because of the size and would like to be able to drop the file in Access to eliminate steps...

Thanks in advance for helping out...

Re: Concatenate Column Values from Multiple Rows into a Single Column

Similar problem sort of but should be in its own thread and not hijack the current one. So I have moved to its own thread.

Re: Concatenate Column Values from Multiple Rows into a Single Column

OK, Sorry... :-(