Convert data from one format to another

Hi everyone,

I have data exported in a certain format and need to change it to a different format, i'm not sure what terminology i can use to explain this so i will create examples below.

This is what the Current Data looks like
Id Number| Value A| Value B| Value C| Value D|
10010506 | 510.03 | 20045 | 324.84| 457.95|
10010507 | 400.56 | 15045 | 245.12| 243.54|
10010508 | 246.56 | 10010 | 854.54| 527.16|
10010509 | 365.56 | 15234 | 652.26| 324.85|
10010510 | 845.56 | 29536 | 418.64| 642.37|


Data needs to be converted to look like this for an Import template

Id Number| V Type|V Amount
10010506 |Value A|510.03
10010506 |Value B|20045
10010506 |Value C|324.84
10010506 |Value D|457.95
10010507 |Value A|400.56
10010507 |Value B|15045
10010507 |Value C|245.12
10010507 |Value D|243.54

Etc....

Does anyone know a feature/formulas etc i can use to achieve these results?

I've played around with Pivot Tables, Subtotals, and attempted power query which i haven't had experience in.

I hope someone can help out?

Thanks!
Penny

Awesome! Thank you MrShorty! The thread guided me in the right direction and then i googled some websites to figure out how to unpivot.

I found this page super useful with instructions to unpivot data: https://www.excelcampus.com/tables/unpivot-power-query/