On 16/03/2012 12:33 PM, Zucco wrote:
Hey i need help transposing multiple sets of data to columns. I have a
couple hundred and don't want to do each by hand any suggestions?


Home Slice Pizza
1415 SOUTH CONGRESS AVE · Austin, Texas · 78704-2434
Pizza Restaurant
2,572 were here · 139 likes


Double Dave's Pizzaworks
Austin, Texas
Pizza Restaurant
1,118 were here · 53 likes


Brooklyn Heights
14900 Avery Ranch Blvd · Austin, Texas · 78717
Pizza Restaurant
2,270 were here · 228 likes · Open until 12:00 am.


California Pizza Kitchen
3401 Esperanza Xing Ste 100 · Austin, Texas · 78758-8705
Pizza Restaurant
1,253 were here · 67 likes


Red House Pizzeria
1917 Manor Road · Austin, Texas · 78722
Pizza Restaurant
1,136 were here · 91 likes


Hoeks Death Metal Pizza
511 E. 6th Street · Austin, Texas · 78701
Pizza Restaurant
1,525 were here · 3,948 likes · Open until 3:00 am.


Double Dave's Pizzaworks
3000 Duval St · Austin, Texas · 78705-3823
Pizza Restaurant
375 were here · 28 likes


Salvation Pizza
624 W 34th St · Austin, Texas · 78705-1203
Pizza Restaurant
506 were here · 80 likes


Double Daves Pizza Works
11900 Metric Blvd Ste F · Austin, Texas · 78758-3121
Pizza Restaurant
437 were here · 23 likes


Brick Oven Restaurant
9911 Brodie Ln Ste 600 · Austin, Texas · 78748-5964
Pizza Restaurant · Italian Restaurant · Family Style Restaurant
465 were here · 24 likes




Would be easier if you showed what columns which was in as the
representation does not fit your request of multiple columns.

Also, did you want to add a % of the "Likes" to the total "Were Here"

A B C D E
1 NAME ADDRESS TYPE ATTENDEES LIKES
2

If it is laid out like you have presented above, it will require VB to
move each line up and over to the corresponding row for each.

HTH
Mick.