| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
transforming poll data from rows to colums
Hi,
I need to rearrange data on two sheets to a third. As a amateur I would appreciate any help! Thank you Ulf Sheet01 contains "data" replies: ReplyId QuestNo QuestName QuestText QuestAltValue 6402 1 Member? 1 Yes 6402 3 Prefers? 3 Milk 6403 1 Member? 2 No 6403 3 Prefers? 1 Beer 6403 4 Age? 55 Sheet02 contains "text" replies: ReplyId QuestNo QuestName QuestText QuestAltValue 6402 2 Name? steve 6402 5 City? London 6403 2 Name? john 6403 5 City? Paris What I need is Sheet03 with one row per ReplyId - and one column per QuestNo ReplyId Member? Name? Prefers? Age? City? 6402 1 Yes Steve 3 Milk London 6403 2 No John 1 Beer 55 Paris |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Chart disappears if you hide rows/colums with data. | Excel Discussion (Misc queries) | |||
| converting data in colums to rows | Excel Discussion (Misc queries) | |||
| Can I rearrange data entered in rows into colums in Excel? | Excel Discussion (Misc queries) | |||
| analyzing poll data | Excel Programming | |||
| Macro & Command Key to change data from Colums to rows | Excel Programming | |||
![ulfb[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
