The attached Workbook contains a macro (ColToTable) that does what you describe. It's not elegant but appears to work. If you have any questions let me know. Tom
On Wed, Nov 19, 2008 at 12:43 PM, KO <[EMAIL PROTECTED]> wrote: > > Hey all- > > I have been searching every Excel help site I can find to get a > solution to this. If anyone has any suggestions, it would be awesome. > I have 2 columns of data in a spreadsheet. They look something like > this: > > source1 > All Visits 1234 > Paid 1000 > Non-Paid 234 > source2 > All Visits 1100 > Paid 1000 > Non-Paid 100 > source3 > All Visits 500 > Paid 250 > Non-Paid 250 > > I want it to look like this: > > All Visits Paid Non-Paid > source1 1234 1000 234 > source2 1100 1000 100 > source3 500 250 250 > > The thing is, there are 500 sources. So I figured macros would be the > best way to solve this. Any suggestions? > > Thanks for your help, > Kristen > > > > > --~--~---------~--~----~------------~-------~--~----~ Visit the blog to download Excel tutorials at http://www.excel-macros.blogspot.com To post to this group, send email to excel-macros@googlegroups.com For more options, visit this group at http://groups.google.com/group/excel-macros?hl=en Visit & Join Our Orkut Community at http://www.orkut.com/Community.aspx?cmm=22913620 Visit the blog to download Excel tutorials at http://www.excel-macros.blogspot.com To Learn VBA Macros Please visit http://www.vbamacros.blogspot.com To see the Daily Excel Tips, Go to: http://exceldailytip.blogspot.com -~----------~----~----~----~------~----~------~--~---
ColToTable.xls
Description: MS-Excel spreadsheet
