Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to convert vertical blocked list to horizontal list? | Excel Worksheet Functions | |||
how do i convert vertical data into horizontal data | Excel Discussion (Misc queries) | |||
Import Data From Landscape Format | New Users to Excel | |||
cannot get excel sheet to print landscape even when set landscape | Setting up and Configuration of Excel | |||
transposing vertical data to horizontal with varying amount of data | Excel Discussion (Misc queries) |