 |
 Stiga 46 Masters Single Competition Table Tennis Racket $29.95 Time Remaining: 28d 5h 18m Buy It Now for only: $29.95 |
 1988 2004 Olympic Table Tennis Mens Singles Finals DVD $9.99 Time Remaining: 19d 3h 28m Buy It Now for only: $9.99 |
 Bud Light Lime Single shade lamp Billiard Ball Triangle Rack 8 ball pool table $84.95 Time Remaining: 29d 20h 41m Buy It Now for only: $84.95 |
 2009 World Table Tennis Championship Mens Single 4 DVD $29.99 Time Remaining: 24d 8h 57m Buy It Now for only: $29.99 |
 Stiga 58 Ultra Single Tournament Table Tennis Racket $64.95 Time Remaining: 28d 5h 15m Buy It Now for only: $64.95 |
 Valley Cougar pool table single piece slate 93 or 88 your choice 93 88 inch $799.99 Time Remaining: 13d 15h 51m Buy It Now for only: $799.99 |
 Pack of 3 Coors Light 14 Inch Single Shade Bar Lamp Pool Table Poker Man Cave $195.95 Time Remaining: 29d 18h 34m Buy It Now for only: $195.95 |
 25th Asian Cup 2012 Table Tennis DVD Mens Singles NEW $10.99 Time Remaining: 4d 14h 38m Buy It Now for only: $10.99 |
 2012 20th Asian Table Tennis Championships Mens Singles DVD $10.99 Time Remaining: 22d 10h 50m Buy It Now for only: $10.99 |
 Stiga Assault 38 Performance Quality Single Table Tennis Racket $24.95 Time Remaining: 28d 5h 24m Buy It Now for only: $24.95 |
 Stiga Attack 34 Performance Quality Single Table Tennis Racket $19.95 Time Remaining: 28d 5h 27m Buy It Now for only: $19.95 |
 25th Asian Cup 2012 Table Tennis DVD Womens Singles NEW $10.99 Time Remaining: 4d 14h 43m Buy It Now for only: $10.99 |
 Custom Tornado T 3000 Foosball Table Single Goalie $1,999.00 Time Remaining: 2d 11h 11m Buy It Now for only: $1,999.00 |
 2008 Beijing Olympics Mens Singles Table Tennis 4 DVD Round of 64 $21.99 Time Remaining: 1d 12h 53m Buy It Now for only: $21.99 |
 2011 Volkswagen China Open Mens Singles Table Tennis DVD $9.99 Time Remaining: 1d 14h 6m Buy It Now for only: $9.99 |
 2007 German Open Mens Singles Table Tennis DVD NEW $8.99 Time Remaining: 16d 4h 28m Buy It Now for only: $8.99 |
 Tornado T 3000 Foosball Table Single Goalie $1,779.00 Time Remaining: 2d 12h 1m Buy It Now for only: $1,779.00 |
 2011 Volkswagen China Open Womens Singles Table Tennis DVD $9.99 Time Remaining: 1d 14h 38m Buy It Now for only: $9.99 |
 2008 Beijing Olympics Mens Singles Table Tennis 4 DVD $29.99 Time Remaining: 16d 5h 54m Buy It Now for only: $29.99 |
 Stiga Xtreme 40 Performance Quality Single Table Tennis Racket $26.95 Time Remaining: 28d 5h 20m Buy It Now for only: $26.95 |
 2007 China Open Table Tennis Womens Singles DVD $8.99 Time Remaining: 1d 18h 6m Buy It Now for only: $8.99 |
 2005 World Table Tennis Championships Mens Singles DVD $9.99 Time Remaining: 17d 2h 30m Buy It Now for only: $9.99 |
 New Diamond Ball Polisher Single Platter Billiard Pool Table $450.00 Time Remaining: 21d 4h 38m Buy It Now for only: $450.00 |
 Tornado T 3000 Coin Foosball Table Single Goalie $1,999.00 Time Remaining: 2d 11h 45m Buy It Now for only: $1,999.00 |
 2008 Brazilian Open Table Tennis DVD Mens Singles NEW $9.99 Time Remaining: 16d 4h 45m Buy It Now for only: $9.99 |
 21st Asian Cup 2008 Table Tennis DVD Womens Singles $8.99 Time Remaining: 16d 4h 31m Buy It Now for only: $8.99 |
 21st Asian Cup 2008 Table Tennis DVD Mens Singles NEW $9.99 Time Remaining: 16d 4h 32m Buy It Now for only: $9.99 |
 2007 Swedish Open Table Tennis DVD MENS SINGLES NEW $9.99 Time Remaining: 16d 4h 42m Buy It Now for only: $9.99 |
 2008 Volkswagen China Open Singles Table Tennis 2 DVD $18.99 Time Remaining: 16d 4h 27m Buy It Now for only: $18.99 |
 2011 World Table Tennis Championship Mens Single DVD $39.99 Time Remaining: 1d 11h 48m Buy It Now for only: $39.99 |
 2008 Beijing Olympics Mens Singles Table Tennis 4 DVD Round of 32 $24.99 Time Remaining: 1d 12h 51m Buy It Now for only: $24.99 |
 2007 French Open Mens Singles Table Tennis DVD NEW $9.99 Time Remaining: 16d 4h 25m Buy It Now for only: $9.99 |
 2009 Qatar Open Mens Singles Table Tennis DVD NEW $9.99 Time Remaining: 29d 5h 54m Buy It Now for only: $9.99 |
 2008 Beijing Olympics Mens Singles Table Tennis 3 DVD $14.99 Time Remaining: 17d 1h 33m Buy It Now for only: $14.99 |
 2008 Beijing Olympics Mens Singles Table Tennis 4 DVD $19.99 Time Remaining: 17d 1h 41m Buy It Now for only: $19.99 |
 2009 World Table Tennis Championship Womens Single DVD $19.99 Time Remaining: 10d 10h 1m Buy It Now for only: $19.99 |
 2007 Russian Open Table Tennis DVD MENS SINGLES NEW $9.99 Time Remaining: 16d 4h 38m Buy It Now for only: $9.99 |
 2008 Panasonic China Open Mens Single Table Tennis DVD $9.99 Time Remaining: 16d 4h 24m Buy It Now for only: $9.99 |
 2011 World Table Tennis Championship Women Single DVD $29.99 Time Remaining: 29d 18h 28m Buy It Now for only: $29.99 |
 2008 Beijing Olympic Womens Singles Table Tennis 4 DVD $23.99 Time Remaining: 17d 2h 24m Buy It Now for only: $23.99 |
 2004 Athens Olympics Table Tennis 3 DVD MENS SINGLES $21.99 Time Remaining: 17d 13h 27m Buy It Now for only: $21.99 |
 2007 Table Tennis Grand Finals Mens Singles 2 DVD $19.99 Time Remaining: 17d 2h 26m Buy It Now for only: $19.99 |
 2007 World Table Tennis Championship Mens Single 6 DVD $39.99 Time Remaining: 17d 2h 27m Buy It Now for only: $39.99 |
 2008 Beijing Olympic Womens Singles Table Tennis 5 DVD $32.99 Time Remaining: 17d 1h 7m Buy It Now for only: $32.99 |
 2007 China Open Table Tennis Mens Singles 2 DVD Set $17.99 Time Remaining: 16d 4h 39m Buy It Now for only: $17.99 |
 NEW Authentic Adidas Ping Pong Paddle Case Single Table Tennis Bag Cover 3 Balls $19.79 Time Remaining: 9d 16h 37m Buy It Now for only: $19.79 |
How can I easily turn a large Excel table into a single-column table using Offset?
It's a table of prices recorded in specific time intervals, that need to be arranged into a single column for easier application and formulas. It's currently arranged by days (rows) and months (columns) [the daily prices of interest, arranged by month, so there is going to be some differences in the length of each column].
What's the formula, given that the first price starts at cell A5?
Here is a macro that will take all of the data in a selected range of cells and copy it to a column.
To install the macro...
Alt+F11 to open the VBA editor
Select from the VBA menu, InsetModule
Paste the code below in the edit window.
Back in Excel, select the range of cells you want to copy to one column.
Run the macro Data_to_Column
The macro will prompt you to select a starting cell to copy the data to.
---
Sub Data_to_Column()
Dim rData As Range
Dim r As Range, c As Range
Dim rStart As Range
Dim counter As Integer
Set rData = Selection
On Error Resume Next
Application.DisplayAlerts = False
Set rStart = Application.InputBox( _
Prompt:="Select the 1st cell you want to copy the data to.", _
Title:="Select Output Location", _
Type:=8)
On Error GoTo 0
Application.DisplayAlerts = True
If rStart Is Nothing Then Exit Sub
For Each c In rData.Columns
For Each r In rData.Rows
If Not IsEmpty(Cells(r.Row, c.Column)) Then
rStart.Offset(counter, 0) = Cells(r.Row, c.Column)
counter = counter + 1
End If
Next r: Next c
End Sub
Niwa vs Hung - Men's Singles Table Tennis - Gold Medal Match - Singapore 2010 Youth Games