google sheets
So lets say I have sheet1
a | 4
b | 5
c | 33
d | 55
and sheet2
a | 1
b | 2
c | 3
e | 2
And on sheet3 I want to get it in this kind of format.
name | average | number of times referenced?
a 2.5 2
b 3.5 2
c 18 2
d 55 1
e 2 1
How would I go about doing this?
Either adapt the QUERY to sort according to the desired column (and then again for a different choice), for example to sort on average descending insert
order by Avg(Col2) desc
before label, or:
Select/Copy/Paste special/Paste values only and then apply the standard sheet sorting.
You want a pivot table.
Select the original data, choose Data > Pivot Table.
From the Pivot Table Editor, add as ROW the column "Date", as COLUMN the "Country", and as VALUE the "Title"
Result:
Best Answer
Please try something like:
Adjust ranges to suit those you did not mention.
QUERY
For your sample not necessary but you might want to insert
order by Col1 ascbeforelabel.