Transposing csv file in python using jupyter : ****Disclaimer, I am a beginner in coding so please go easy , thanks in advance*****

How do you transpose the  data before saving  the data to a csv file using python in jupyter?
 Here is my code>>
  

      import csv
    
    Col1 = "Product Name"
    Col2 = "Product Image Is Thumbnail - 1"
    Col3 = "Product Code/SKU"
    Col4 = "Product Description"
    Col5 = "Price"
    Col6 = "Cost Price"
    Col7 = "Product Image File - 1"
    Col8 = "Product Image File - 2"
    
    
    mydictionary={Col1:[], Col2:[], Col3:[], Col4 :[], Col5:[], Col6:[],  Col7:[], Col8:[]}
    csvFile = csv.reader(open("wedding.csv"))
    for row in csvFile:
      mydictionary[Col1].append(row[2])
      mydictionary[Col2].append(row[6])
      mydictionary[Col3].append(row[4])
      mydictionary[Col4].append(row[11]) 
      mydictionary[Col5].append(row[7])
      mydictionary[Col6].append(row[8])
      mydictionary[Col7].append(row[9])
      mydictionary[Col8].append(row[10])
            
    
    print (mydictionary)
    
    with open('test.csv', 'w') as csv_file1:
        writer = csv.writer(csv_file1, delimiter=' ',
                                quotechar='|', quoting=csv.QUOTE_MINIMAL)
        for key, value in mydictionary.items():
           writer.writerow([key, value])``


