How to transpose such a structure in Excel 2007?

Question

Visual Basic

Hello,
There was a situation such that I need to repeat one of my dynamic tables from the database in Excel 2007. And something doesn’t work out how to do it right in it. Now I will show how it is implemented in excel office 365 with power query.
I take the columns I need -
1) ProcedureId - This is the user ID
2) TokenValue - This is the question ID
3) HtmlValue - This is the answer or answer ID
The questionnaire is the same for all users.

Next, I write fx and get the structure I need -

.                      Вопрос 1     Вопрос 2       Вопрос 3 
Айди пользователя 1    Ответ 1      Ответ 2        Ответ 3
Айди пользователя 2    Ответ 1      Ответ 2        Ответ 3

= Table.Pivot(#"Removed Other Columns", List.Distinct(#"Removed Other Columns"[TokenValue]), "TokenValue", "HtmlValue")

So, now the problem itself is with excel 2007.
Here is a separate sheet from which data from the database is displayed. When creating a new sheet, I cannot repeat the previous code.

I'm trying using this
=TRANSPOSE(Sheet1!A17736:C18550)
. But it's stupid, because you need the user's designation to remain in the column.
How can I correctly do the same as the example above only in Excel 2007? Again, the data is dynamic.
Thanks in advance for your reply!