View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
[email protected] glyn.devine@gmail.com is offline
external usenet poster
 
Posts: 1
Default Grouping/Transposing CSV File?

Hi All, I've got a CSV file with two fields, product code and group. I
can get it into Excel just fine, what I want to do is convert the
groups into columns. Like, I'd want the "GOLF" column to have those 4
product codes beneath it.



002-0001-GOTIPPER GOLF
002-0002-GOTIPMOT GOLF
002-QUIC-GOLFTIPS GOLF
003-QUIC-GOLFGAME GOLF
004-QUIC-CASINOGA BUSINESS
005-0001-HOMEMAIN BUSINESS
005-QUIC-HOMEMAIN BUSINESS
006-QUIC-ROADSAFE SAFETY
007-QUIC-INDUSAFE SAFETY
008-QUIC-OFFISAFE SAFETY
009-QUIC-INTERNET BUSINESS
010-QUIC-BORGIDEA BUSINESS

Can someone help me out? I'm quite new to Excel.