Add Columns based on Data in separate query

Is there a way to create new columns in a query based on a separate data query?  I would like to accomplish something similar to a pivot table where you can assign a data field as the columns and have the row values be determined by the column