I'm previously a SAS user - since I don't have SAS anymore I need to learn to use R for work.
The dataset has the following column:

```
market date sitename impression clicks

```

I want to transpose it into:

```
market date sitename-impression  sitename-clicks

```

I think in SAS I used to do:

```
Proc Transpose
by market date;
id sitename;
var impression clicks;
run;

```

I do have a book on R and googled a lot, but couldn't find the solution that works...

Would really appreciate if anyone can help.

Thanks in advance!!!