Combining 4 rows into 1 on a dataset
We use Google Analytics and I have pulled in data from 4 segments. The data in the table gives 4 rows per day with a column for the segments (there are 4) and another column for my other metric. I would like to combine the segment name and metric data to a column (ie...'segment name' as the column header with the value being the metric...revenue or sessions) for each segment creating one row. Any thoughts?