How to move column to row

[iosiflupis]

Hello,

I have a table with three columns. Date, Location, and Count. What I would like to do is keep the Date column as it is, make the Location column into three separate columns (Garage, Preferred, and Outdoor) and then populate the rows with the counts that correspond to the date by location. I have tried group by (basic and Advanced), Transpose, Unpivot Columns with no luck.

I have attached a screenshot of the current table.

 

[johnny51981]

You actually want to Pivot, rather than Unpivot.

Highlight your Location column, then go Transform > Pivot Column. In the Values Column select your Count column. Under the Advanced Option, Aggregate Value Function select Sum.

 

[iosiflupis]

Johnny51981 Thank you! worked like a champ!