For people out there that need to do this in either excel or access here are solutions, I spent last night looking at it and there are some great timesavers.
to make fields go from un-normalised to normalised use
select sample as Sample1 , " value1 " AS col, Value1 from Table1 where value1 is not null
union all
select sample as Sample2 , " value2 " AS col, value2 from Table2 where value2 is not null
union all
Hopefully most of you will know this but hope its of some use
Credit to Max for the excel file, its great.
to make fields go from un-normalised to normalised use
select sample as Sample1 , " value1 " AS col, Value1 from Table1 where value1 is not null
union all
select sample as Sample2 , " value2 " AS col, value2 from Table2 where value2 is not null
union all
Hopefully most of you will know this but hope its of some use
Credit to Max for the excel file, its great.
