Authentic voices. Remarkable stories. AOL On Originals showcase the passions that make the world a more interesting place.
In a compelling series of verite encounters, Win Win provides unique access into the minds and lives of the world’s most-celebrated entrepreneurs and athletes.
Explore what it means to be human as we rush head first into the future through the eyes, creativity, and mind of Tiffany Shlain, acclaimed filmmaker and speaker, founder of The Webby Awards, mother, constant pusher of boundaries and one of Newsweek’s “women shaping the 21st Century.”
Nicole Richie brings her unfiltered sense of humor and unique perspective to life in a new series based on her irreverent twitter feed. The show follows the outspoken celebrity as she shares her perspective on style, parenting, relationships and her journey to adulthood.
Comedy is hard, but teaching comedy to children is hilariously difficult. Kevin Nealon is giving the challenge to some world-famous comedians. As these young minds meet with comedy’s best, get ready to learn some valuable comedy lessons, and to laugh!
James Franco loves movies. He loves watching them, acting in them, directing them, and even writing them. And now, he’s going to take some of his favorite movie scenes from the most famous films of all time, and re-imagine them in ways that only James can.
The story of punk rock singer Laura Jane Grace of Against Me! who came out as a woman in 2012, and other members of the trans community whose experiences are woefully underrepresented and misunderstood in the media.
Executive produced by Zoe Saldana (who will be the subject of one episode), a celebrity travels back to their hometown to pay tribute to the one person from their past (before they were famous) who helped change their life by giving them an over-the-top, heart-felt surprise.
Enter the graceful but competitive world of ballet through the eyes of executive producer, Sarah Jessica Parker. This behind-the-scenes docudrama reveals what it takes to perform on the ultimate stage, the New York City Ballet. Catch NYCB on stage at Lincoln Center.
Park Bench is a new kind of "talking show" straight from the mind of born and bred New Yorker and host, Steve Buscemi.
Go behind the scenes with some of the biggest digital celebrities to see what life is like when the blogging and tweeting stops.
Digital influencer Justine Ezarik (iJustine) is back. After covering the world of wearable tech last season, iJustine is expanding her coverage this year by profiling the hottest tech trends across the country.
Documentary shorts conceived of and directed by famous actors. Jeff Garlin, Katie Holmes, Alia Shawkat, Judy Greer, and James Purefoy
A 12 episode documentary series following 5 startup companies competing in the 2013 San Francisco TechCrunch Disrupt Startup Battlefield as they fine tune their products and eventually present in front of a panel of judges in hopes of winning $50,000 in funding.
Paula asks how to take a range and turn it on its side. Episode 1173 shows you how.
Tags:How to Transpose Excel Column Data,Excel Transpose Function,How to Transpose Excel Column Data into Row Data,how to transpose in excel,How to Transpose Rows into Columns in Excel,How to Turn a Range Sideways in Excel,MrExcel
Grab video code:
Bill Jelen: The Me. Excel Podcast is brought to you by Easy-XL. Hey, welcome back to the Mr. Excel net cast. I’m Bill Jelen with today’s question sent in by Paula. Paula lives in Washington. Paula sent me a spreadsheet with different data which I’ve changed to kind of protect the confidentiality there. Paula says, “Hey, I need to take that yellow range and turn it sideways into the blue range.”
As far as an excel pro as you want to know, this is something called transpose. Transpose traditionally was on the paste special dialog and we’ll do that first. So we’re going to copy this. I’m going to use Control C to copy and then come up here to C13 and we’re not going to paste, we’re going to paste special. So you can use paste, paste special and down here at the very bottom is something called transpose, click OK.
Alright, so now if you’re new to transpose, I need to call out one interesting problem with transpose. I like that Paula had this question “How about if I take the Iverson and move it to Iverson’s?” Really, if you think about this, really if you think about this, she could have asked how do I take this range, let's make it a green range, and move it to be in this area. I mean that would be just a very natural thing to want to do, right? But unfortunately, your transpose will not let you do that. Control C to copy, and then if we come here and try and do paste, paste special, transpose, well, the problem is going to be that the paste range include it’s one cell in common with the copy range, so when I click OK the selection is not valid here, not allowed to overlap when we’re doing transpose. You have to be very careful that you are going to a new spot.
Now, if you’re in Excel 2007 it’s even easier, you can do the copy, select the new cells and it just use paste, transpose and that will turn sideways. In Excel 2010 it’s going to be even easier with that great new visual past options dialog box but we have to wait for Excel 2010 to get to that.
So I want to thank Paula for sending that question in and I want to thank you for stopping by. See you next time for another net cast from Mr. Excel.