Export Multiple rowns into a single cell in Excel

[bkelly101]

I need to export a list of data into a single cell in Excel.



As an example the list looks like this in Access:

450a

650b

320c

4100d

and exports into individual cells. I need it to export into one cell and look like this:
450a, 650b, 320c, 4100d

Any help would be appreciated.

Thanks.
Brenda

[June7]

Review: http://allenbrowne.com/func-concat.html

[bkelly101]

Hi...Thanks for the information.

First question, can this be used in Access 2003? How do I download the VBA function ConcatRelated?

[bkelly101]

Here is how I need it to look. Please help with the actual query. Thank you.

TableName	TblHouses
QueryName	QryHouses
TblHouses
Fields	ID (AutoNumber)	House (Text)	Colour (Text)
	1	Greeley	Green
	2	Greeley	Orange
	3	Greeley	Blue
	4	Crestwood	Blue
	5	Crestwood	Pink
	6	Crestwood	White
Results to look
Greeley	Green, Orange, Pink
Crestwood	Blue, Pink, White

[June7]

The code is good for Access 2003.

Copy/paste the code from the web page.

Attempt code in your database and when you have specific issue, post question.

The query would call the function in an expression.

This topic has been discussed in other threads:
https://www.accessforums.net/access/...ain-24474.html
https://www.accessforums.net/queries...row-23882.html