The transpose table operation in Power Query rotates your table 90 degrees, turning your rows into columns and your columns into rows. Imagine a table like the one in the following image, with three rows and four columns. Table with four columns named Column1 through Column4, with all columns set to the Text data type. Read More