Hi Everyone,
I have a report which I generate on a regular basis and need to convert from a tabular view to a matrix view for readability.
I use Excel 2013
I would appreciate if anyone could assist me with some VBA code to accomplish the following:
Some of the remaining column headers from the original report will be used as the column headers for the new report with the exception of column "F", which will be the 6 different records, or course names, listed in the Original Report and will be column headers for columns "B" to "G" in the new report. These 6 headers will always remain the same.
Below is a sample data set from the Original Report, which have hundreds more records. The non-required columns, as listed above, have already been removed for a better view, the remaining columns in " ":
Original Report:
[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD][TABLE="width: 74"]
<tbody>[TR]
[TD="width: 74"]"A"
Learner[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD]"F"
[TABLE="width: 64"]
<tbody>[TR]
[TD="width: 64"]Course[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD]"J"
[TABLE="width: 64"]
<tbody>[TR]
[TD="width: 64"]Completion Date[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD]"V"
[TABLE="width: 64"]
<tbody>[TR]
[TD="width: 64"]LOCATION CODE[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD]"AC"
[TABLE="width: 64"]
<tbody>[TR]
[TD="width: 64"]mgrname[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD]"AH"
[TABLE="width: 64"]
<tbody>[TR]
[TD="width: 64"]POSITION 1[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
[TR]
[TD][TABLE="width: 74"]
<tbody>[TR]
[TD="width: 74, align: center"]Ali Md AKBAR[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 64"]
<tbody>[TR]
[TD="width: 64, align: center"]ELDER ABUSE, MISSING PERSONS AND COMPULSORY REPORTING[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 98"]
<tbody>[TR]
[TD="class: xl65, width: 98, align: center"]15-Jun-17[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 64"]
<tbody>[TR]
[TD="width: 64, align: center"]MHH[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 130"]
<tbody>[TR]
[TD="width: 130, align: center"]Chui Kiong KING[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 186"]
<tbody>[TR]
[TD="width: 186, align: center"]Care Worker[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
[TR]
[TD][TABLE="width: 74"]
<tbody>[TR]
[TD="width: 74, align: center"]Ali Md AKBAR[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 64"]
<tbody>[TR]
[TD="width: 64, align: center"]FIRE SAFETY: THE BASIC PRINCIPLES[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 98"]
<tbody>[TR]
[TD="class: xl65, width: 98, align: center"]20-Feb-19[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 64"]
<tbody>[TR]
[TD="width: 64, align: center"]MHH[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 130"]
<tbody>[TR]
[TD="width: 130, align: center"]Chui Kiong KING[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 186"]
<tbody>[TR]
[TD="width: 186, align: center"]Care Worker[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
[TR]
[TD][TABLE="width: 74"]
<tbody>[TR]
[TD="width: 74, align: center"]Ali Md AKBAR[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 64"]
<tbody>[TR]
[TD="width: 64, align: center"]FOOD SAFETY[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 98"]
<tbody>[TR]
[TD="class: xl65, width: 98, align: center"]30-Oct-18[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 64"]
<tbody>[TR]
[TD="width: 64, align: center"]MHH[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 130"]
<tbody>[TR]
[TD="width: 130, align: center"]Chui Kiong KING[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 186"]
<tbody>[TR]
[TD="width: 186, align: center"]Care Worker[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
[TR]
[TD][TABLE="width: 74"]
<tbody>[TR]
[TD="width: 74, align: center"]Ali Md AKBAR[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 64"]
<tbody>[TR]
[TD="width: 64, align: center"]INFECTION CONTROL: AN OVERVIEW (R-AU)[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 98"]
<tbody>[TR]
[TD="class: xl65, width: 98, align: center"]19-Feb-19[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 64"]
<tbody>[TR]
[TD="width: 64, align: center"]MHH[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 130"]
<tbody>[TR]
[TD="width: 130, align: center"]Chui Kiong KING[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 186"]
<tbody>[TR]
[TD="width: 186, align: center"]Care Worker[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
[TR]
[TD][TABLE="width: 74"]
<tbody>[TR]
[TD="width: 74, align: center"]Ali Md AKBAR[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 64"]
<tbody>[TR]
[TD="width: 64, align: center"]WHS: PREVENTING MUSCULOSKELETAL INJURY AT WORK (R-AU)[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 98"]
<tbody>[TR]
[TD="class: xl65, width: 98, align: center"]11-Feb-19[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 64"]
<tbody>[TR]
[TD="width: 64, align: center"]MHH[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 130"]
<tbody>[TR]
[TD="width: 130, align: center"]Chui Kiong KING[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 186"]
<tbody>[TR]
[TD="width: 186, align: center"]Care Worker[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
[TR]
[TD][TABLE="width: 74"]
<tbody>[TR]
[TD="width: 74, align: center"]Ali Md AKBAR[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 64"]
<tbody>[TR]
[TD="width: 64, align: center"]WHS: SAFE MANUAL HANDLING (AUS)[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 98"]
<tbody>[TR]
[TD="class: xl65, width: 98, align: center"]04-Apr-18[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 64"]
<tbody>[TR]
[TD="width: 64, align: center"]MHH[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 130"]
<tbody>[TR]
[TD="width: 130, align: center"]Chui Kiong KING[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 186"]
<tbody>[TR]
[TD="width: 186, align: center"]Care Worker[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
[TR]
[TD][TABLE="width: 74"]
<tbody>[TR]
[TD="width: 74, align: center"]Alina Sophia SLATER[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 64"]
<tbody>[TR]
[TD="width: 64, align: center"]ELDER ABUSE, MISSING PERSONS AND COMPULSORY REPORTING[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 98"]
<tbody>[TR]
[TD="class: xl65, width: 98, align: center"]20-Jun-17[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 64"]
<tbody>[TR]
[TD="width: 64, align: center"]MHH[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 130"]
<tbody>[TR]
[TD="width: 130, align: center"]Chui Kiong KING[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 186"]
<tbody>[TR]
[TD="width: 186, align: center"]Care Worker[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
[TR]
[TD][TABLE="width: 74"]
<tbody>[TR]
[TD="width: 74, align: center"]Alina Sophia SLATER[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 64"]
<tbody>[TR]
[TD="width: 64, align: center"]FOOD SAFETY[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 98"]
<tbody>[TR]
[TD="class: xl65, width: 98, align: center"]25-Jun-18[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 64"]
<tbody>[TR]
[TD="width: 64, align: center"]MHH[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 130"]
<tbody>[TR]
[TD="width: 130, align: center"]Chui Kiong KING[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 186"]
<tbody>[TR]
[TD="width: 186, align: center"]Care Worker[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
[TR]
[TD][TABLE="width: 74"]
<tbody>[TR]
[TD="width: 74, align: center"]Alina Sophia SLATER[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 64"]
<tbody>[TR]
[TD="width: 64, align: center"]WHS: SAFE MANUAL HANDLING (AUS)[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 98"]
<tbody>[TR]
[TD="class: xl65, width: 98, align: center"]20-Jun-18[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 64"]
<tbody>[TR]
[TD="width: 64, align: center"]MHH[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 130"]
<tbody>[TR]
[TD="width: 130, align: center"]Chui Kiong KING[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 186"]
<tbody>[TR]
[TD="width: 186, align: center"]Care Worker[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
[TR]
[TD][TABLE="width: 74"]
<tbody>[TR]
[TD="width: 74"][TABLE="width: 74"]
<tbody>[TR]
[TD="width: 74, align: center"]Alison Mary BROWN[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 64"]
<tbody>[TR]
[TD="width: 64, align: center"]ELDER ABUSE, MISSING PERSONS AND COMPULSORY REPORTING[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 98"]
<tbody>[TR]
[TD="class: xl65, width: 98, align: center"]16-Mar-18[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 64"]
<tbody>[TR]
[TD="width: 64, align: center"]MHH[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 130"]
<tbody>[TR]
[TD="width: 130, align: center"]Jessie Twan Tee HO[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 186"]
<tbody>[TR]
[TD="width: 186, align: center"]Physiotherapist - Residential[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
[TR]
[TD][TABLE="width: 74"]
<tbody>[TR]
[TD="width: 74"][TABLE="width: 74"]
<tbody>[TR]
[TD="width: 74, align: center"]Alison Mary BROWN[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 64"]
<tbody>[TR]
[TD="width: 64, align: center"]WHS: PREVENTING MUSCULOSKELETAL INJURY AT WORK (R-AU)[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 98"]
<tbody>[TR]
[TD="class: xl65, width: 98, align: center"]02-Apr-19[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 64"]
<tbody>[TR]
[TD="width: 64, align: center"]MHH[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 130"]
<tbody>[TR]
[TD="width: 130, align: center"]Jessie Twan Tee HO[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 186"]
<tbody>[TR]
[TD="width: 186, align: center"]Physiotherapist - Residential[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
[TR]
[TD][TABLE="width: 74"]
<tbody>[TR]
[TD="width: 74"][TABLE="width: 74"]
<tbody>[TR]
[TD="width: 74, align: center"]Alison Mary BROWN[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 64"]
<tbody>[TR]
[TD="width: 64, align: center"]WHS: SAFE MANUAL HANDLING (AUS)[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 98"]
<tbody>[TR]
[TD="class: xl65, width: 98, align: center"]19-Jul-18[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 64"]
<tbody>[TR]
[TD="width: 64, align: center"]MHH[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 130"]
<tbody>[TR]
[TD="width: 130, align: center"]Jessie Twan Tee HO[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 186"]
<tbody>[TR]
[TD="width: 186, align: center"]Physiotherapist - Residential[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
[TR]
[TD][TABLE="width: 74"]
<tbody>[TR]
[TD="width: 74, align: center"]Amandeep KAUR[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 64"]
<tbody>[TR]
[TD="width: 64, align: center"]ELDER ABUSE, MISSING PERSONS AND COMPULSORY REPORTING[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 98"]
<tbody>[TR]
[TD="class: xl65, width: 98, align: center"]14-Dec-17[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 64"]
<tbody>[TR]
[TD="width: 64, align: center"]MHH[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 130"]
<tbody>[TR]
[TD="width: 130, align: center"]Chui Kiong KING[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD="align: center"]Care Worker[/TD]
[/TR]
[TR]
[TD][TABLE="width: 74"]
<tbody>[TR]
[TD="width: 74, align: center"]Amandeep KAUR[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 64"]
<tbody>[TR]
[TD="width: 64, align: center"]FOOD SAFETY[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 98"]
<tbody>[TR]
[TD="class: xl65, width: 98, align: center"]21-Jun-18[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 64"]
<tbody>[TR]
[TD="width: 64, align: center"]MHH[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 130"]
<tbody>[TR]
[TD="width: 130, align: center"]Chui Kiong KING[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 186"]
<tbody>[TR]
[TD="width: 186, align: center"]Care Worker[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
[TR]
[TD][TABLE="width: 74"]
<tbody>[TR]
[TD="width: 74, align: center"]Amandeep KAUR[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 64"]
<tbody>[TR]
[TD="width: 64, align: center"]INFECTION CONTROL: AN OVERVIEW (R-AU)[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 98"]
<tbody>[TR]
[TD="class: xl65, width: 98, align: center"]19-Mar-19[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 64"]
<tbody>[TR]
[TD="width: 64, align: center"]MHH[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 130"]
<tbody>[TR]
[TD="width: 130, align: center"]Chui Kiong KING[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 186"]
<tbody>[TR]
[TD="width: 186, align: center"]Care Worker[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
[TR]
[TD][TABLE="width: 74"]
<tbody>[TR]
[TD="width: 74, align: center"]Amandeep KAUR[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 64"]
<tbody>[TR]
[TD="width: 64, align: center"]WHS: PREVENTING MUSCULOSKELETAL INJURY AT WORK (R-AU)[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 98"]
<tbody>[TR]
[TD="class: xl65, width: 98, align: center"]19-Mar-19[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 64"]
<tbody>[TR]
[TD="width: 64, align: center"]MHH[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 130"]
<tbody>[TR]
[TD="width: 130, align: center"]Chui Kiong KING[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 186"]
<tbody>[TR]
[TD="width: 186, align: center"]Care Worker[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
[TR]
[TD][TABLE="width: 74"]
<tbody>[TR]
[TD="width: 74, align: center"]Amandeep KAUR[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 64"]
<tbody>[TR]
[TD="width: 64, align: center"]WHS: SAFE MANUAL HANDLING (AUS)[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 98"]
<tbody>[TR]
[TD="class: xl65, width: 98, align: center"]21-Mar-18[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 64"]
<tbody>[TR]
[TD="width: 64, align: center"]MHH[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 130"]
<tbody>[TR]
[TD="width: 130, align: center"]Chui Kiong KING[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 186"]
<tbody>[TR]
[TD="width: 186, align: center"]Care Worker[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
</tbody>[/TABLE]
Converted Report: (This is what the new report will look like)
[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD="align: center"]"A"
Learner[/TD]
[TD]
<tbody>[TR]
[TD="class: xl65, width: 136, align: center"]ELDER ABUSE, MISSING PERSONS AND COMPULSORY REPORTING[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD]
<tbody>[TR]
[TD="class: xl65, width: 117, align: center"]FIRE SAFETY: THE BASIC PRINCIPLES[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD]
<tbody>[TR]
[TD="class: xl65, width: 117, align: center"]FOOD SAFETY[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD]
<tbody>[TR]
[TD="class: xl65, width: 117, align: center"]INFECTION CONTROL: AN OVERVIEW (R-AU)[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD]
<tbody>[TR]
[TD="class: xl65, width: 117, align: center"]WHS: PREVENTING MUSCULOSKELETAL INJURY AT WORK (R-AU)[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD]
<tbody>[TR]
[TD="class: xl65, width: 117, align: center"]WHS: SAFE MANUAL HANDLING (AUS)[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD="align: center"]"H"
LOCATION CODE[/TD]
[TD]
<tbody>[TR]
[TD="class: xl65, width: 64, align: center"]mgrname[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD]
<tbody>[TR]
[TD="class: xl65, width: 64, align: center"]POSITION 1[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
[TR]
[TD][TABLE="width: 134"]
<tbody>[TR]
[TD="width: 134, align: center"]Ali Md AKBAR[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 136"]
<tbody>[TR]
[TD="class: xl65, width: 136, align: center"]15-Jun-17[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 117"]
<tbody>[TR]
[TD="class: xl65, width: 117, align: center"]20-Feb-19[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 117"]
<tbody>[TR]
[TD="class: xl65, width: 117, align: center"]30-Oct-18[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 117"]
<tbody>[TR]
[TD="class: xl65, width: 117, align: center"]19-Feb-19[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 117"]
<tbody>[TR]
[TD="class: xl65, width: 117, align: center"]11-Feb-19[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 117"]
<tbody>[TR]
[TD="class: xl65, width: 117, align: center"]04-Apr-18[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD="align: center"]MHH[/TD]
[TD][TABLE="width: 64"]
<tbody>[TR]
[TD="width: 64, align: center"]Chui Kiong KING[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 64"]
<tbody>[TR]
[TD="width: 64, align: center"]Care Worker[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
[TR]
[TD][TABLE="width: 134"]
<tbody>[TR]
[TD="width: 134, align: center"]Alina Sophia SLATER[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 136"]
<tbody>[TR]
[TD="class: xl65, width: 136, align: center"]20-Jun-17[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD="align: center"][/TD]
[TD][TABLE="width: 117"]
<tbody>[TR]
[TD="class: xl65, width: 117, align: center"]25-Jun-18[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD][TABLE="width: 117"]
<tbody>[TR]
[TD="class: xl65, width: 117, align: center"]20-Jun-18[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD="align: center"]MHH[/TD]
[TD][TABLE="width: 64"]
<tbody>[TR]
[TD="width: 64, align: center"]Chui Kiong KING[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 64"]
<tbody>[TR]
[TD="width: 64, align: center"]Care Worker[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
[TR]
[TD][TABLE="width: 134"]
<tbody>[TR]
[TD="width: 134, align: center"]Alison Mary BROWN[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 136"]
<tbody>[TR]
[TD="class: xl65, width: 136, align: center"]16-Mar-18[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD][TABLE="width: 117"]
<tbody>[TR]
[TD="class: xl65, width: 117, align: center"]02-Apr-19[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 117"]
<tbody>[TR]
[TD="class: xl65, width: 117, align: center"]19-Jul-18[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD="align: center"]MHH[/TD]
[TD][TABLE="width: 64"]
<tbody>[TR]
[TD="width: 64, align: center"]Jessie Twan Tee HO[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 64"]
<tbody>[TR]
[TD="width: 64, align: center"]Physiotherapist - Residential[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
[TR]
[TD][TABLE="width: 134"]
<tbody>[TR]
[TD="width: 134, align: center"]Amandeep KAUR[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 136"]
<tbody>[TR]
[TD="class: xl65, width: 136, align: center"]14-Dec-17[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD="align: center"][/TD]
[TD][TABLE="width: 117"]
<tbody>[TR]
[TD="class: xl65, width: 117, align: center"]21-Jun-18[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 117"]
<tbody>[TR]
[TD="class: xl65, width: 117, align: center"]19-Mar-19[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 117"]
<tbody>[TR]
[TD="class: xl65, width: 117, align: center"]19-Mar-19[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 117"]
<tbody>[TR]
[TD="class: xl65, width: 117, align: center"]21-Mar-18[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD="align: center"]MHH[/TD]
[TD][TABLE="width: 64"]
<tbody>[TR]
[TD="width: 64, align: center"]Chui Kiong KING[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 64"]
<tbody>[TR]
[TD="width: 64, align: center"]Care Worker[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
</tbody>[/TABLE]
Hopefully I have explained the requirement in such a way that it makes sense. Please let me know should you require more information.
I have a report which I generate on a regular basis and need to convert from a tabular view to a matrix view for readability.
I use Excel 2013
I would appreciate if anyone could assist me with some VBA code to accomplish the following:
- Delete all non-required columns, in this case " B to E, G, H, I, K to U, W to AB, AD to AG, AI to AO (35 of the original 41 to be deleted) The same columns will always be deleted.
- Then change the layout and view to a matrix, please see "Converted Report" below.
Some of the remaining column headers from the original report will be used as the column headers for the new report with the exception of column "F", which will be the 6 different records, or course names, listed in the Original Report and will be column headers for columns "B" to "G" in the new report. These 6 headers will always remain the same.
Below is a sample data set from the Original Report, which have hundreds more records. The non-required columns, as listed above, have already been removed for a better view, the remaining columns in " ":
Original Report:
[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD][TABLE="width: 74"]
<tbody>[TR]
[TD="width: 74"]"A"
Learner[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD]"F"
[TABLE="width: 64"]
<tbody>[TR]
[TD="width: 64"]Course[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD]"J"
[TABLE="width: 64"]
<tbody>[TR]
[TD="width: 64"]Completion Date[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD]"V"
[TABLE="width: 64"]
<tbody>[TR]
[TD="width: 64"]LOCATION CODE[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD]"AC"
[TABLE="width: 64"]
<tbody>[TR]
[TD="width: 64"]mgrname[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD]"AH"
[TABLE="width: 64"]
<tbody>[TR]
[TD="width: 64"]POSITION 1[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
[TR]
[TD][TABLE="width: 74"]
<tbody>[TR]
[TD="width: 74, align: center"]Ali Md AKBAR[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 64"]
<tbody>[TR]
[TD="width: 64, align: center"]ELDER ABUSE, MISSING PERSONS AND COMPULSORY REPORTING[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 98"]
<tbody>[TR]
[TD="class: xl65, width: 98, align: center"]15-Jun-17[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 64"]
<tbody>[TR]
[TD="width: 64, align: center"]MHH[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 130"]
<tbody>[TR]
[TD="width: 130, align: center"]Chui Kiong KING[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 186"]
<tbody>[TR]
[TD="width: 186, align: center"]Care Worker[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
[TR]
[TD][TABLE="width: 74"]
<tbody>[TR]
[TD="width: 74, align: center"]Ali Md AKBAR[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 64"]
<tbody>[TR]
[TD="width: 64, align: center"]FIRE SAFETY: THE BASIC PRINCIPLES[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 98"]
<tbody>[TR]
[TD="class: xl65, width: 98, align: center"]20-Feb-19[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 64"]
<tbody>[TR]
[TD="width: 64, align: center"]MHH[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 130"]
<tbody>[TR]
[TD="width: 130, align: center"]Chui Kiong KING[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 186"]
<tbody>[TR]
[TD="width: 186, align: center"]Care Worker[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
[TR]
[TD][TABLE="width: 74"]
<tbody>[TR]
[TD="width: 74, align: center"]Ali Md AKBAR[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 64"]
<tbody>[TR]
[TD="width: 64, align: center"]FOOD SAFETY[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 98"]
<tbody>[TR]
[TD="class: xl65, width: 98, align: center"]30-Oct-18[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 64"]
<tbody>[TR]
[TD="width: 64, align: center"]MHH[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 130"]
<tbody>[TR]
[TD="width: 130, align: center"]Chui Kiong KING[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 186"]
<tbody>[TR]
[TD="width: 186, align: center"]Care Worker[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
[TR]
[TD][TABLE="width: 74"]
<tbody>[TR]
[TD="width: 74, align: center"]Ali Md AKBAR[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 64"]
<tbody>[TR]
[TD="width: 64, align: center"]INFECTION CONTROL: AN OVERVIEW (R-AU)[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 98"]
<tbody>[TR]
[TD="class: xl65, width: 98, align: center"]19-Feb-19[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 64"]
<tbody>[TR]
[TD="width: 64, align: center"]MHH[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 130"]
<tbody>[TR]
[TD="width: 130, align: center"]Chui Kiong KING[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 186"]
<tbody>[TR]
[TD="width: 186, align: center"]Care Worker[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
[TR]
[TD][TABLE="width: 74"]
<tbody>[TR]
[TD="width: 74, align: center"]Ali Md AKBAR[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 64"]
<tbody>[TR]
[TD="width: 64, align: center"]WHS: PREVENTING MUSCULOSKELETAL INJURY AT WORK (R-AU)[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 98"]
<tbody>[TR]
[TD="class: xl65, width: 98, align: center"]11-Feb-19[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 64"]
<tbody>[TR]
[TD="width: 64, align: center"]MHH[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 130"]
<tbody>[TR]
[TD="width: 130, align: center"]Chui Kiong KING[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 186"]
<tbody>[TR]
[TD="width: 186, align: center"]Care Worker[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
[TR]
[TD][TABLE="width: 74"]
<tbody>[TR]
[TD="width: 74, align: center"]Ali Md AKBAR[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 64"]
<tbody>[TR]
[TD="width: 64, align: center"]WHS: SAFE MANUAL HANDLING (AUS)[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 98"]
<tbody>[TR]
[TD="class: xl65, width: 98, align: center"]04-Apr-18[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 64"]
<tbody>[TR]
[TD="width: 64, align: center"]MHH[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 130"]
<tbody>[TR]
[TD="width: 130, align: center"]Chui Kiong KING[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 186"]
<tbody>[TR]
[TD="width: 186, align: center"]Care Worker[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
[TR]
[TD][TABLE="width: 74"]
<tbody>[TR]
[TD="width: 74, align: center"]Alina Sophia SLATER[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 64"]
<tbody>[TR]
[TD="width: 64, align: center"]ELDER ABUSE, MISSING PERSONS AND COMPULSORY REPORTING[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 98"]
<tbody>[TR]
[TD="class: xl65, width: 98, align: center"]20-Jun-17[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 64"]
<tbody>[TR]
[TD="width: 64, align: center"]MHH[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 130"]
<tbody>[TR]
[TD="width: 130, align: center"]Chui Kiong KING[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 186"]
<tbody>[TR]
[TD="width: 186, align: center"]Care Worker[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
[TR]
[TD][TABLE="width: 74"]
<tbody>[TR]
[TD="width: 74, align: center"]Alina Sophia SLATER[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 64"]
<tbody>[TR]
[TD="width: 64, align: center"]FOOD SAFETY[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 98"]
<tbody>[TR]
[TD="class: xl65, width: 98, align: center"]25-Jun-18[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 64"]
<tbody>[TR]
[TD="width: 64, align: center"]MHH[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 130"]
<tbody>[TR]
[TD="width: 130, align: center"]Chui Kiong KING[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 186"]
<tbody>[TR]
[TD="width: 186, align: center"]Care Worker[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
[TR]
[TD][TABLE="width: 74"]
<tbody>[TR]
[TD="width: 74, align: center"]Alina Sophia SLATER[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 64"]
<tbody>[TR]
[TD="width: 64, align: center"]WHS: SAFE MANUAL HANDLING (AUS)[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 98"]
<tbody>[TR]
[TD="class: xl65, width: 98, align: center"]20-Jun-18[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 64"]
<tbody>[TR]
[TD="width: 64, align: center"]MHH[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 130"]
<tbody>[TR]
[TD="width: 130, align: center"]Chui Kiong KING[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 186"]
<tbody>[TR]
[TD="width: 186, align: center"]Care Worker[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
[TR]
[TD][TABLE="width: 74"]
<tbody>[TR]
[TD="width: 74"][TABLE="width: 74"]
<tbody>[TR]
[TD="width: 74, align: center"]Alison Mary BROWN[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 64"]
<tbody>[TR]
[TD="width: 64, align: center"]ELDER ABUSE, MISSING PERSONS AND COMPULSORY REPORTING[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 98"]
<tbody>[TR]
[TD="class: xl65, width: 98, align: center"]16-Mar-18[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 64"]
<tbody>[TR]
[TD="width: 64, align: center"]MHH[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 130"]
<tbody>[TR]
[TD="width: 130, align: center"]Jessie Twan Tee HO[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 186"]
<tbody>[TR]
[TD="width: 186, align: center"]Physiotherapist - Residential[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
[TR]
[TD][TABLE="width: 74"]
<tbody>[TR]
[TD="width: 74"][TABLE="width: 74"]
<tbody>[TR]
[TD="width: 74, align: center"]Alison Mary BROWN[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 64"]
<tbody>[TR]
[TD="width: 64, align: center"]WHS: PREVENTING MUSCULOSKELETAL INJURY AT WORK (R-AU)[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 98"]
<tbody>[TR]
[TD="class: xl65, width: 98, align: center"]02-Apr-19[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 64"]
<tbody>[TR]
[TD="width: 64, align: center"]MHH[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 130"]
<tbody>[TR]
[TD="width: 130, align: center"]Jessie Twan Tee HO[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 186"]
<tbody>[TR]
[TD="width: 186, align: center"]Physiotherapist - Residential[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
[TR]
[TD][TABLE="width: 74"]
<tbody>[TR]
[TD="width: 74"][TABLE="width: 74"]
<tbody>[TR]
[TD="width: 74, align: center"]Alison Mary BROWN[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 64"]
<tbody>[TR]
[TD="width: 64, align: center"]WHS: SAFE MANUAL HANDLING (AUS)[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 98"]
<tbody>[TR]
[TD="class: xl65, width: 98, align: center"]19-Jul-18[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 64"]
<tbody>[TR]
[TD="width: 64, align: center"]MHH[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 130"]
<tbody>[TR]
[TD="width: 130, align: center"]Jessie Twan Tee HO[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 186"]
<tbody>[TR]
[TD="width: 186, align: center"]Physiotherapist - Residential[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
[TR]
[TD][TABLE="width: 74"]
<tbody>[TR]
[TD="width: 74, align: center"]Amandeep KAUR[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 64"]
<tbody>[TR]
[TD="width: 64, align: center"]ELDER ABUSE, MISSING PERSONS AND COMPULSORY REPORTING[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 98"]
<tbody>[TR]
[TD="class: xl65, width: 98, align: center"]14-Dec-17[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 64"]
<tbody>[TR]
[TD="width: 64, align: center"]MHH[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 130"]
<tbody>[TR]
[TD="width: 130, align: center"]Chui Kiong KING[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD="align: center"]Care Worker[/TD]
[/TR]
[TR]
[TD][TABLE="width: 74"]
<tbody>[TR]
[TD="width: 74, align: center"]Amandeep KAUR[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 64"]
<tbody>[TR]
[TD="width: 64, align: center"]FOOD SAFETY[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 98"]
<tbody>[TR]
[TD="class: xl65, width: 98, align: center"]21-Jun-18[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 64"]
<tbody>[TR]
[TD="width: 64, align: center"]MHH[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 130"]
<tbody>[TR]
[TD="width: 130, align: center"]Chui Kiong KING[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 186"]
<tbody>[TR]
[TD="width: 186, align: center"]Care Worker[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
[TR]
[TD][TABLE="width: 74"]
<tbody>[TR]
[TD="width: 74, align: center"]Amandeep KAUR[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 64"]
<tbody>[TR]
[TD="width: 64, align: center"]INFECTION CONTROL: AN OVERVIEW (R-AU)[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 98"]
<tbody>[TR]
[TD="class: xl65, width: 98, align: center"]19-Mar-19[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 64"]
<tbody>[TR]
[TD="width: 64, align: center"]MHH[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 130"]
<tbody>[TR]
[TD="width: 130, align: center"]Chui Kiong KING[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 186"]
<tbody>[TR]
[TD="width: 186, align: center"]Care Worker[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
[TR]
[TD][TABLE="width: 74"]
<tbody>[TR]
[TD="width: 74, align: center"]Amandeep KAUR[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 64"]
<tbody>[TR]
[TD="width: 64, align: center"]WHS: PREVENTING MUSCULOSKELETAL INJURY AT WORK (R-AU)[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 98"]
<tbody>[TR]
[TD="class: xl65, width: 98, align: center"]19-Mar-19[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 64"]
<tbody>[TR]
[TD="width: 64, align: center"]MHH[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 130"]
<tbody>[TR]
[TD="width: 130, align: center"]Chui Kiong KING[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 186"]
<tbody>[TR]
[TD="width: 186, align: center"]Care Worker[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
[TR]
[TD][TABLE="width: 74"]
<tbody>[TR]
[TD="width: 74, align: center"]Amandeep KAUR[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 64"]
<tbody>[TR]
[TD="width: 64, align: center"]WHS: SAFE MANUAL HANDLING (AUS)[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 98"]
<tbody>[TR]
[TD="class: xl65, width: 98, align: center"]21-Mar-18[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 64"]
<tbody>[TR]
[TD="width: 64, align: center"]MHH[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 130"]
<tbody>[TR]
[TD="width: 130, align: center"]Chui Kiong KING[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 186"]
<tbody>[TR]
[TD="width: 186, align: center"]Care Worker[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
</tbody>[/TABLE]
Converted Report: (This is what the new report will look like)
[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD="align: center"]"A"
Learner[/TD]
[TD]
"B"
[TABLE="width: 136"]<tbody>[TR]
[TD="class: xl65, width: 136, align: center"]ELDER ABUSE, MISSING PERSONS AND COMPULSORY REPORTING[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD]
"C"
[TABLE="width: 117"]<tbody>[TR]
[TD="class: xl65, width: 117, align: center"]FIRE SAFETY: THE BASIC PRINCIPLES[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD]
"D"
[TABLE="width: 117"]<tbody>[TR]
[TD="class: xl65, width: 117, align: center"]FOOD SAFETY[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD]
"E"
[TABLE="width: 117"]<tbody>[TR]
[TD="class: xl65, width: 117, align: center"]INFECTION CONTROL: AN OVERVIEW (R-AU)[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD]
"F"
[TABLE="width: 117"]<tbody>[TR]
[TD="class: xl65, width: 117, align: center"]WHS: PREVENTING MUSCULOSKELETAL INJURY AT WORK (R-AU)[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD]
"G"
[TABLE="width: 117"]<tbody>[TR]
[TD="class: xl65, width: 117, align: center"]WHS: SAFE MANUAL HANDLING (AUS)[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD="align: center"]"H"
LOCATION CODE[/TD]
[TD]
"I"
[TABLE="width: 64"]<tbody>[TR]
[TD="class: xl65, width: 64, align: center"]mgrname[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD]
"J"
[TABLE="width: 64"]<tbody>[TR]
[TD="class: xl65, width: 64, align: center"]POSITION 1[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
[TR]
[TD][TABLE="width: 134"]
<tbody>[TR]
[TD="width: 134, align: center"]Ali Md AKBAR[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 136"]
<tbody>[TR]
[TD="class: xl65, width: 136, align: center"]15-Jun-17[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 117"]
<tbody>[TR]
[TD="class: xl65, width: 117, align: center"]20-Feb-19[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 117"]
<tbody>[TR]
[TD="class: xl65, width: 117, align: center"]30-Oct-18[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 117"]
<tbody>[TR]
[TD="class: xl65, width: 117, align: center"]19-Feb-19[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 117"]
<tbody>[TR]
[TD="class: xl65, width: 117, align: center"]11-Feb-19[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 117"]
<tbody>[TR]
[TD="class: xl65, width: 117, align: center"]04-Apr-18[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD="align: center"]MHH[/TD]
[TD][TABLE="width: 64"]
<tbody>[TR]
[TD="width: 64, align: center"]Chui Kiong KING[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 64"]
<tbody>[TR]
[TD="width: 64, align: center"]Care Worker[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
[TR]
[TD][TABLE="width: 134"]
<tbody>[TR]
[TD="width: 134, align: center"]Alina Sophia SLATER[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 136"]
<tbody>[TR]
[TD="class: xl65, width: 136, align: center"]20-Jun-17[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD="align: center"][/TD]
[TD][TABLE="width: 117"]
<tbody>[TR]
[TD="class: xl65, width: 117, align: center"]25-Jun-18[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD][TABLE="width: 117"]
<tbody>[TR]
[TD="class: xl65, width: 117, align: center"]20-Jun-18[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD="align: center"]MHH[/TD]
[TD][TABLE="width: 64"]
<tbody>[TR]
[TD="width: 64, align: center"]Chui Kiong KING[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 64"]
<tbody>[TR]
[TD="width: 64, align: center"]Care Worker[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
[TR]
[TD][TABLE="width: 134"]
<tbody>[TR]
[TD="width: 134, align: center"]Alison Mary BROWN[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 136"]
<tbody>[TR]
[TD="class: xl65, width: 136, align: center"]16-Mar-18[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD][TABLE="width: 117"]
<tbody>[TR]
[TD="class: xl65, width: 117, align: center"]02-Apr-19[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 117"]
<tbody>[TR]
[TD="class: xl65, width: 117, align: center"]19-Jul-18[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD="align: center"]MHH[/TD]
[TD][TABLE="width: 64"]
<tbody>[TR]
[TD="width: 64, align: center"]Jessie Twan Tee HO[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 64"]
<tbody>[TR]
[TD="width: 64, align: center"]Physiotherapist - Residential[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
[TR]
[TD][TABLE="width: 134"]
<tbody>[TR]
[TD="width: 134, align: center"]Amandeep KAUR[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 136"]
<tbody>[TR]
[TD="class: xl65, width: 136, align: center"]14-Dec-17[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD="align: center"][/TD]
[TD][TABLE="width: 117"]
<tbody>[TR]
[TD="class: xl65, width: 117, align: center"]21-Jun-18[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 117"]
<tbody>[TR]
[TD="class: xl65, width: 117, align: center"]19-Mar-19[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 117"]
<tbody>[TR]
[TD="class: xl65, width: 117, align: center"]19-Mar-19[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 117"]
<tbody>[TR]
[TD="class: xl65, width: 117, align: center"]21-Mar-18[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD="align: center"]MHH[/TD]
[TD][TABLE="width: 64"]
<tbody>[TR]
[TD="width: 64, align: center"]Chui Kiong KING[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 64"]
<tbody>[TR]
[TD="width: 64, align: center"]Care Worker[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
</tbody>[/TABLE]
Hopefully I have explained the requirement in such a way that it makes sense. Please let me know should you require more information.
Last edited: