Combining 2 Fields

[one3nine0]

I have a table that has a list of unique text and a second table with list of 3 categories.

I want to be able to build a query that will combine them into 1 table like below.

Text 1	Name
Text 2	Name
Text 3	Name
Text 1	Size
Text 2	Size
Text 3	Size
Text 1	Distribution
Text 2	Distribution
Text 3	Distribution

<tbody>
</tbody>

How would be the best way to do that?

 

[Micron]

What you want to do is very bad form (create a un-normalized table) because the values in the second column have litttle or no relationship to each other. However, if you insist, try making a select query between using the two tables (text table on left and category on the right) and create a right join on category to text. If you get what you want, make that query an append or make table query to put the data in one table. If not, try a left join. If not, you will probably need a union query. The reason for my uncertainty is that you don't give much information regarding the data types or field names.

Again, I think anyone who knows about database normal form would advise against what you're doing.

 

[one3nine0]

The reason I need it in this format, is basically because I am using "bad form" in Powerpivot, to unpivot these values to create separate charts in 1 chart, via slicers created by the categories. It's not how I'd prefer to work but what the customer wants, is what the customer gets (most of the time)

Basically, the table with the unique text is a record of sales with a unique identifier (the unique text) in text format. This table gets updated every month. The category table is just a list of 3 categories that stays constant, that needs to be matched up with each unique identifier.

I can do this in excel, but Access can handle large amounts of data better and I can automate the process.

I'll try what you suggest and hopefully that will solve my problem.

 

[one3nine0]

Ok, in access didnt need to make any joins. Just a select into a table query worked. I didnt think it would.