Mike Miazga
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
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Define 'doesn't like'.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
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!
ASKER