| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming,microsoft.public.access
|
|||
|
|||
Transpose to different sheet
Sorry for the cross-posting, but I'm not sure where this is better placed.
I need to take the data from an Access table and turn it into column headers in an Excel spreadsheet. I can easily export the data to a spreadsheet (call it sheet A), but it appears as a column. I then need to determine how many entries there are in the column, insert that number of columns in another spreadsheet in a different workbook (call it sheet B) and transpose the column in sheet A to populate row 1 in sheet B. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how do I transpose items from another sheet? | Excel Discussion (Misc queries) | |||
| how do i transpose a Polynomial equation from a graph to a sheet? | Excel Discussion (Misc queries) | |||
| Transpose from one sheet to the next and leave out blank cells | Excel Discussion (Misc queries) | |||
| Filling a listbox with transpose of a range from an excel sheet | Excel Programming | |||
| Excel VBA - How to transpose every fifth row to same column on another sheet | Excel Programming | |||
Threaded Mode
