Posted to microsoft.public.excel.misc

vilfood

external usenet poster

Posts: 1

How to transpose in excel file

Hi I would like to make a transpose like this?
From
House Defect How much
#1 Broken Sinks 1000
#1 Bad Paint 2000
#1 Bad Lighting 1000
#2 Broken Sinks 0
#2 Bad Paint 2000
#2 Bad Lighting 100

and Transpose into
House Broken Sinks Bad Paint Bad Lighting
#1 1000 2000 1000
#2 0 2000 100

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Excel TRANSPOSE	lolita	Excel Worksheet Functions	0	October 28th 09 03:31 PM
Transpose Crosstab Data in Excel 2000 to flat file for use in MS A	Syak	Excel Discussion (Misc queries)	4	August 23rd 06 06:05 PM
Hi all i need some help on excel transpose	ash	Excel Worksheet Functions	1	May 2nd 06 01:19 PM
Hi all need some help in excel transpose	ash	Excel Discussion (Misc queries)	5	May 2nd 06 10:17 AM
I WANT TO TRANSPOSE LINKS, AS WE TRANSPOSE VALUES	Umair Aslam	Excel Worksheet Functions	1	September 22nd 05 01:19 PM

All times are GMT +1. The time now is 04:48 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us