Probably the most important thing to include with your question is to be specific with the environment information.
I also have data stored out in the cloud. It happens that I happen to be working with MS SQL Server which actually has native support for
PIVOT
.
Similar functions are available in some other databases, such as Oracle.
Other database types (such as MySql or MariaDB) do not have native PIVOT or similar functions and require tools. One of these is called
dbForge Studio
.
So... your answer depends primarily on what type of DB you are running.
1. There are some links below to review
2. Be specific when using Google for db questions-
MySQL pivot
One of the most important things to remember is that a database is primarily for storing data. Secondary functions such as reporting and text manipulations are often better performed at the presentation layer.
And don't forget... Excel can be hooked up to use a database for it's information source, and it is where most people learn PIVOT
References:
Using PIVOT and UNPIVOT - SQL Server | Microsoft Docs[
^]
Pivot Tables in MySQL[
^]
SQL Pivot in all databases: MySQL, MariaDB, SQLite, PostgreSQL, Oracle, …[
^]
MySQL GUI Tool - MariaDB and MySQL Front End Client[
^]