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

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