Hi all
I wanted to know if it possible to create a new table query or multiple queries to stack data in a row from an existing table. Basically I have the bellow records in table 1
Car | Crash test 1 | Crash test 2
Ford PASS Fail
BMW PASS PASS
VW FAIL FAIL
MERCEDES PASS Blank
Ferrari FAIL Blank
create table 2 so the data looks like this
Car | Crash test |
Ford PASS
Ford Fail
BMW PASS
BMW PASS
VW FAIL
VW FAIL
MERCEDES PASS
Ferrari FAIL
thanks so much all xXx