As you can see, your data will flip the other way.Head down to Paste Options > click on the Transpose icon.Right-click on the cell where you want the newly positioned data to start displaying.This doesn’t work if you cut data, so make sure you’re copying, and not cutting. First, highlight the data you’d like to move, and then copy it by either right-clicking or holding Ctrl + C (Windows) or Command + C (Mac).

Let’s say you have a row of data, and you’d like this data to be vertical in a column instead.

Don’t change it manually–use Excel’s Transpose function instead. I guess that i am not the first one having these kind of issue or need but unfortunately i was not able to find anything which could give me a hint of what i could do to solve this in an elegant manner.Here’s a quick trick in Excel that can be really handy if you’ve started to enter some data in a row, but decide that you’d like it in a column instead (or vice versa). Now what i would need to do is that fow any item and Type the LOCATION culumns must be 'transposed' onto the lines which should look somehow like this Item So basically i partially need to transpose only the columns of Locations onto the lines => this is what it actually looks like What i would need to do now, is to replicate these 2 lines (Inventory & Sales) for ANY of these location columns and insert the appropriate values there. The problem is that any product repeats itself twice (2 Rows - 1 x Inventory + 1 x Sales) and then the appropriate values per location are displayed on the columns (Loc A | Loc B | Loc C etc.).

I have the following situation - i have an excel sheet which shows me the inventory and sales of several products in different locations. now that i have started using it i already stumbled over my first big issue which i could not solve by myself. Hello to all! I am completely new to this community and to powerbi and query in general but already found the great benefits you might have by properly using this tool.

Transpose excel 365