I have stated this is a cross tab query, but strickly it might not be, so looking for a better description.
I have two columns which contain data which I need to malipuate from a large table.
I really need to get a query which will display the data
ColA ColB ColB ColB ColB
1 1 2 3
2 4 5 6
I really hope this is simple, but I have been stumped for a couple of days now, any help much appreacted.