Transpose#
Description:
Swap rows and columns in a Table
Function:
Transpose(table = string, new_table_name = string)
Parameters:
Table: Table name on which to perform function
New Table Name: Name for new table
Example:
Transpose(table = Budget, new_table_name = "Transposed")
Date |
Geo |
Plan |
Actual |
|---|---|---|---|
8/1/2024 |
United States, Energy |
800 |
750 |
9/1/2024 |
Asia-Pacific, Technology |
1500 |
850 |
7/1/2024 |
Middle East & Africa |
1200 |
900 |
5/1/2024 |
Latin America, Manufacturing |
900 |
1050 |
11/1/2024 |
Latin America, Energy |
2000 |
1800 |
Date |
column_0 |
column_1 |
column_2 |
column_3 |
column_4 |
|---|---|---|---|---|---|
Geo |
United States, Energy |
Asia-Pacific, T. |
Middle East & Africa |
Latin America, Manufacturing |
Latin America, Energy |
Plan |
800 |
1500 |
1200 |
900 |
2000 |
Actual |
750 |
850 |
900 |
1050 |
1800 |