How would I change my data formatting on my excel sheet

[Jackf99]

How would I change the format of my data set from this 

ID	Form17	Form18	Form19
1	Walmart	18	1
2	Cosco	2	6

To this,

Code	Name
Comp[1].Form17	Walmart
Comp[1].Form18	18
Comp[1].Form19	1
Comp[2].Form17	Cosco
Comp[2].Form18	2
Comp[2].Form19	6

Where the number in between brackets is the id

[binu_acs · Accepted solution]

@Jackf99 transpose the data

[Jackf99]

Lol i realized right after post but didnt know how to delete whoops