Hi
Apologies if I have worded this wrong, I couldn't seem to find any help on the net regarding this method.
Basically I have 1 row of data as shown below
I would like to be able to have it transposed as below
I have many other columns inbetween the sku and Min Max prices, so not really after a formula that can transpose. I have attempted using the power query editor but I cannot get it to do as needed. I would like to be able to use the power query method rather than using VBA which is what the majority of posts I have stumbled upon recommend. So any help or advice on where I can learn how to apply this to my data would be great. Many Thanks!
Apologies if I have worded this wrong, I couldn't seem to find any help on the net regarding this method.
Basically I have 1 row of data as shown below
I would like to be able to have it transposed as below
I have many other columns inbetween the sku and Min Max prices, so not really after a formula that can transpose. I have attempted using the power query editor but I cannot get it to do as needed. I would like to be able to use the power query method rather than using VBA which is what the majority of posts I have stumbled upon recommend. So any help or advice on where I can learn how to apply this to my data would be great. Many Thanks!