Unpivot question

Hi, Anonymous 

You can use the following steps to unpivot and transpose the data. Here is the sample.

1 Use Headers as First Row

2 Transpose the table

3 Use First Row as Headers

4 Add a Custom column with country name and drag it to proper location to reorder the column

5 Do the same operations to other queries and then Append Queries as New to get a new query

The result looks like this:

Best Regards,

Caiyun Zheng

Is that the answer you're looking for? If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.