Please can anyone assist me on how I can easily transpose this data on the left A-C so it looks like the one on the right E-G, the idea is to have a simple order sheet for the client to add the quantity they want then transpose the data to look like (Column E-G)
Thank you!

​Please can anyone assist me on how I can easily transpose this data on the left A-C so it looks like the one on the right E-G, the idea is to have a simple order sheet for the client to add the quantity they want then transpose the data to look like (Column E-G)Thank you!  Read More

​