View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Jackanorry Jackanorry is offline
external usenet poster
 
Posts: 14
Default filter imported data to columns - can no one help?



"Jackanorry" wrote:

I am looking to import data (numerical) to rows that will filter column.
Fort example .:. if numbers being imported are 5,7,9 35 and will correspond
to specific date, then each number needs to be filtered to the column with
header (label) of the same value.

# of columns 50


Therefore data once imported would look like this:

A B C D E F G H I ...... AI
1 2 3 4 5 6 7 8 9 ..... 35
DATE........... 3........ 5.......7...................35