Crosstable on multiple column groups

[danaleota1]

Hello I am trying to use crosstable prefix on multiple column groups.  I am wanting to change more than one group of columns to:

Date, Emp Name, Question No, Question Name, Order, Answer Type , Result with two qualifying columns. 

Would I still use a Crosstable prefix for this?  Example of the load statement before adding the crosstable prefix.

LOAD
    "Emp Name",
 "Question 1 Id",
    Name,
    "Order",
    "Answer Type",
    Result,
    "Question 2 Id",
    Name1,
    Order1,
    "Answer Type1",
    Result1,
    "Question 3 Id",
    Name2,
    Order2,
    "Answer Type2",
    Result2,
FROM [Results.xlsx]
(ooxml, embedded labels, table is Results);

[Lisa_P · Accepted solution]

I would load multiple times and concatenate together into one table: LOAD "Emp Name", "Question 1 Id" as QuestionID, Name, "Order", "Answer Type", Result FROM [Results.xlsx] (ooxml, embedded labels, table is Results); Concatenate LOAD "Emp Name", "Question 2 Id" as QuestionID, Name1 as Name, Order1 as Order, "Answer Type1" as "Answer Type" Result1 as Result FROM [Results.xlsx] (ooxml, embedded labels, table is Results); etc

[danaleota1]

Thank you Lisa that worked! 

[Hope_AA]

Hi Lisa,

I saw your answer to the above and I was wondering if there is a way to show the original format on one of the Qlik sheets after you make them into a cross table?

[Lisa_P]

Create a pivot table to make it appear like the source