View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
liem liem is offline
external usenet poster
 
Posts: 22
Default How to convert data from Landscape to vertical

I have a data file with 6000 stores and 45 questions but the data came in
this way below and this is sample of four stores with 4 questions

store Landscape Fruit Flower Tree --------
12345 Y N Y N
25565 N Y Y N
35685 Y Y Y Y
25487 N N N Y

I need to convert data to this format below with three columns so I can use
Ms access feed

Store reponsed Question
12345 Y landscape
12345 N fruit
12345 Y Flower
12345 N tree
25565 N landscape
25565 Y fruit
25565 Y Flower
25565 N tree
35685 Y landscape
35685 Y fruit
35685 Y Flower
35685 Y tree
25487 N landscape
25487 N fruit
25487 N Flower
25487 Y tree

please help

--
thanks