Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
macro for transposing data
i have multiple rows, each with varing numbers of columns. i need to
get it so that each columns has it own row. i have over 1000 columns and was hoping to get a macro can transpose the data for me?? for example: I have something like this: A 3 4 7 B 5 2 9 1 5 I need it to look like this: A 3 A 4 A 7 B 5 B 2 B 9 B 1 B 5 can someone help me?! =o) |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
macro to sort data in worksheet by specific date | Excel Discussion (Misc queries) | |||
Creating a macro to save only partial data | Excel Discussion (Misc queries) | |||
Macro that will add data from multiple workbooks to the 1st open r | Excel Discussion (Misc queries) | |||
Extract specific data into its own workbook via macro? | Excel Discussion (Misc queries) | |||
Daily Macro to Download Data, Order and paste in order | Excel Worksheet Functions |