Spreadsheet: 683020d1592433827-data-formatting-issue-sample-data-privac-
Sheet: Sheet2

[NAME]
Country | 2019 Product A | 2019 Product B | 2019 Product C | 2019 Product D | 2020 Product A | 2020 Product B | 2020 Product C | 2020 Product D | 2021 Product A | 2021 Product B | 2021 Product C | 2021 Product D
 | 2019 |  |  |  | 2020 |  |  |  | 2021 |  |  |  |  | 1. Type Country in A2
 | Product A | Product B | Product C | Product D | Product A | Product B | Product C | Product D | Product A | Product B | Product C | Product D |  | 2. Unmerge B3:J3 and then utilize Find & Select > Go To Special > Blanks > =B3 > Ctrl + Enter
India | 100 | 200 | 300 | 400 | 200 | 300 | 400 | 500 | 400 | 500 | 600 | 700 |  | 3. Populate B2:M3 using: =B3&" "&B4
Australia | 101 | 201 | 301 | 401 | 201 | 301 | 401 | 501 | 401 | 501 | 601 | 701 |  | 4. [NAME]:M8 to a table (this will convert the formulas in row 2 into text values).
New Zealand | 102 | 202 | 302 | 402 | 202 | 302 | 402 | 502 | 402 | 502 | 602 | 702
England | 103 | 203 | 303 | 403 | 203 | 303 | 403 | 503 | 403 | 503 | 603 | 700
The output should look like this:
Product | Country | Year | Value |  | Product | Country | Year | Value
Product A | India | 2019 | 100 |  | Product A | Australia | 2019 | 101
Product A | Australia | 2019 | 101 |  | Product A | New Zealand | 2019 | 102
Product A | New Zealand | 2019 | 102 |  | Product A | England | 2019 | 103
Product A | England | 2019 | 103 |  | Product A | India | 2019 | 100
Product A | India | 2020 | 200 |  | Product A | New Zealand | 2020 | 202
Product A | Australia | 2020 | 201 |  | Product A | Australia | 2020 | 201
Product A | New Zealand | 2020 | 202 |  | Product A | India | 2020 | 200
Product A | England | 2020 | 203 |  | Product A | England | 2020 | 203
Product A | India | 2021 | 400 |  | Product A | New Zealand | 2021 | 402
Product A | Australia | 2021 | 401 |  | Product A | England | 2021 | 403
Product A | New Zealand | 2021 | 402 |  | Product A | Australia | 2021 | 401
Product A | England | 2021 | 403 |  | Product A | India | 2021 | 400
 |  |  |  |  | Product B | New Zealand | 2019 | 202
 |  |  |  |  | Product B | Australia | 2019 | 201
 |  |  |  |  | Product B | England | 2019 | 203
 |  |  |  |  | Product B | India | 2019 | 200
 |  |  |  |  | Product B | England | 2020 | 303
 |  |  |  |  | Product B | Australia | 2020 | 301
 |  |  |  |  | Product B | New Zealand | 2020 | 302
 |  |  |  |  | Product B | India | 2020 | 300
 |  |  |  |  | Product B | New Zealand | 2021 | 502
 |  |  |  |  | Product B | England | 2021 | 503
 |  |  |  |  | Product B | India | 2021 | 500
 |  |  |  |  | Product B | Australia | 2021 | 501
 |  |  |  |  | Product C | India | 2019 | 300
 |  |  |  |  | Product C | England | 2019 | 303
 |  |  |  |  | Product C | Australia | 2019 | 301
 |  |  |  |  | Product C | New Zealand | 2019 | 302
 |  |  |  |  | Product C | New Zealand | 2020 | 402
 |  |  |  |  | Product C | Australia | 2020 | 401
 |  |  |  |  | Product C | England | 2020 | 403
 |  |  |  |  | Product C | India | 2020 | 400
 |  |  |  |  | Product C | New Zealand | 2021 | 602
 |  |  |  |  | Product C | Australia | 2021 | 601
 |  |  |  |  | Product C | India | 2021 | 600
 |  |  |  |  | Product C | England | 2021 | 603
 |  |  |  |  | Product D | England | 2019 | 403
 |  |  |  |  | Product D | New Zealand | 2019 | 402
 |  |  |  |  | Product D | Australia | 2019 | 401
 |  |  |  |  | Product D | India | 2019 | 400
 |  |  |  |  | Product D | England | 2020 | 503
 |  |  |  |  | Product D | Australia | 2020 | 501
 |  |  |  |  | Product D | New Zealand | 2020 | 502
 |  |  |  |  | Product D | India | 2020 | 500
 |  |  |  |  | Product D | England | 2021 | 700
 |  |  |  |  | Product D | India | 2021 | 700
 |  |  |  |  | Product D | Australia | 2021 | 701
 |  |  |  |  | Product D | New Zealand | 2021 | 702