Im looking to transform data output into a matrix.
The data - continous table:
Date Names Topics
1/1/01 Tom;Dick;Harry topic1;topic2;topic3
7/1/01 Dick;Harry topic1;topic4
The matrix required:
Topic1 Topic2...
I have a table:
Name Current Course Expiry
Pete Yes Excel 30/1/19
Pete Yes Word 30/1/19
Pete2 Yes Excel 5/2/19
Pete3 No Excel 1/11/18
I would like to create a Matrix:
Name...