Thread: dget and dsum
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Henry Henry is offline
external usenet poster
 
Posts: 61
Default dget and dsum

shift 1 shift 2 shift 3
1/1/2008 32 45 28
1/2/2008 49 36 73
1/3/2008 21 16 81

Have data as above and would like to make it as below:
1/1/2008 32
1/1/2008 45
1/1/2008 28
1/2/2008 49
1/2/2008 36
1/2/2008 73

Have 270 plus lines of data and have been trying to use dget but
can't seem to get it to work