View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Jackanorry Jackanorry is offline
external usenet poster
 
Posts: 14
Default filter imported data to columns

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