#1   Report Post  
Joe
 
Posts: n/a
Default list to table

i have three coloums of data (no numbers all words)
i would like to leave coloum A as a list (but filter out the duplicate)
coloum b i would like to have a titles accross the top and coloum C i would
like to have as like data in the table.
I have tried using a pivot table but as coloum C is data it will not give me
the result that i am after.

has anybody got any ideas?
Cheers


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

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
Pivot Table Sort & Top List excel_user123456 Excel Discussion (Misc queries) 0 June 23rd 05 08:53 PM
how to delete/clean out the row list in pivot table john² Excel Worksheet Functions 1 May 26th 05 04:56 AM
Creating a list from Table Data bry32 Excel Worksheet Functions 4 January 28th 05 07:41 PM
List Running Horizontally-Pivot Table Possible? Jugglertwo Excel Discussion (Misc queries) 3 December 24th 04 05:29 AM
convert excel list to pivot table GI Excel Discussion (Misc queries) 0 December 6th 04 06:45 PM


All times are GMT +1. The time now is 01:24 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"