# pivot

```
IntuneDevices
| summarize arg_max(TimeGenerated, *) by SerialNumber
| where OS == 'Windows'
| project OSVersion, Manufacturer
| evaluate pivot(OSVersion)
```

<figure><img src="https://3533425259-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2Fbx8yn20QqNJtsVaH9CY7%2Fuploads%2Ffw6pqfDCMWmL0eWHszrI%2Fimage.png?alt=media&#x26;token=8ba4234a-0508-468c-adab-4a2be3062dba" alt=""><figcaption></figcaption></figure>