(no subject)
Aug. 14th, 2007 03:14 pm![[personal profile]](https://www.dreamwidth.org/img/silk/identity/user.png){kind=small}
mirajeI have a question for you Excel whizzes. Let's say I have lots and lots (BIG understatement) of data in a spreadsheet that is formatted like this:
Is there a way in Excel that I can transpose the data so that it reads like this?
| SITE_ID | DATE_TIME | WATER_LEVEL |
| 1234 | 5/01/2007 | 31.00 |
| 1234 | 5/02/2007 | 30.00 |
| 1234 | 5/03/2007 | 35.00 |
| 5555 | 5/01/2007 | 25.00 |
| 5555 | 5/02/2007 | 24.00 |
| 5555 | 5/03/2007 | 23.00 |
Is there a way in Excel that I can transpose the data so that it reads like this?
| 5/01/2007 | 5/02/2007 | 5/03/2007 | |
| 1234 | 31.00 | 30.00 | 35.00 |
| 5555 | 25.00 | 24.00 | 23.00 |
![[identity profile]](https://www.dreamwidth.org/img/silk/identity/openid.png){kind=small}
(no subject)
Date: 2007-08-17 06:09 pm (UTC)