Crosstab Queries

jex57

Board Regular
Joined
Oct 29, 2015
Messages
53
Hi
I have a table that has data as follows:
1583474685497.png


(column name and table name)

I am trying to create a crosstab query which will give me the results that look as follows:

1583474891069.png


Any suggestions on how to do this?
Thank you
 

Some videos you may like

Excel Facts

Excel Wisdom
Using a mouse in Excel is the work equivalent of wearing a lanyard when you first get to college

xenou

MrExcel MVP, Moderator
Joined
Mar 2, 2007
Messages
16,601
Office Version
2013
Platform
Windows
Hi, I don't think this can be done with a crosstab query.
 

ranman256

Well-known Member
Joined
Jun 17, 2014
Messages
1,840
a crosstab need 3 values so you cant, but a report could do it on your table.

group on Col.Name field, then show table.names
but set the report in PAGE SETUP to print N columns,
Left-Right THEN Top-Down.


not perfect, but it will work.
 

Forum statistics

Threads
1,089,220
Messages
5,406,928
Members
403,113
Latest member
ms_excel_recal_or_die

This Week's Hot Topics

Top