I have two data sets, which are structured differently. I am trying to bring the data together in a single column to calculate my revenue.
Is there a way to Transpose (rotate) the data in a Pipeline, from horizontal to vertical? In Excel when you copy and then paste, you can use the Transpose function.
Using the following as an example, I would like to make 2016-09-01 the measure (column header) and have the numbers down the page: with company in column one:
- One column wide
- Seven rows deep