Link to home
Start Free TrialLog in
Avatar of Mike Miazga
Mike MiazgaFlag for United States of America

asked on

Transpose rows to columns?

I've got an excel spreadsheet with data that looks like this:

LocationNo      DemograpicItem            DemographicTotal
2400200            Building Size                    0
2400200            Indoor Variance            0
2400200            Lot Size                            5043
2400200            Number of Floors         1
2400200            Occupants                    0
2400200            Outdoor Variance              0
2400200            Units                         0
2400202            Building Size                   0
2400202            Indoor Variance            0
2400202            Lot Size                           0
2400202            Number of Floors         1
2400202            Occupants                    0
2400202            Outdoor Variance               0
2400202            Units                           0

I need it to look like:

Location No.     BuildingSize    IndooorVariance    LotSize etc etc
2400200             0                        0                               5043  etc etc
2400202             0                        0                                0


How can I do this via excel or SQL server?  

Thanks
SOLUTION
Avatar of Jim Horn
Jim Horn
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Mike Miazga

ASKER

It doesn't like transpose.  That's why i asked the question.  I've figured it out using SQL Server.  Thanks.
Define 'doesn't like'.
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Won't paste.  Says the copy and paste size are different for the whole set of data.  I actually got it to transpose, but it's not what I'm looking for as it's also transposing the locationno into columns.  I need that to stay a single row.  I was able to get what I needed creating new tables for each demographic item, then combining the tables.  Thanks for your responses.
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
ASKER CERTIFIED SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Probably jumped the gun in asking the question. I had tried paste/transpose, pivot table etc without it working as I needed it to.  I used SQL server to parse out each item into its own table and combined all the tables on locationno.   Thanks for all the suggestions!