Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Rearranging columns/rows
I have a spreadsheet of the form
NAME BOOK1 BOOK2 BOOK3... Bob aaa bbbb cccc Jill ddd eee Fred fff Jack ggg hhhh which I want to reformat into the form NAME BOOK Bob aaa Bob bbb Bob ccc Jill ddd Jill eee Fred fff etc Can anybody suggest the best way to do this? The no. of BOOKx columns will vary, and because the spreadsheet will be a regular one, I'll need a macro or such to automate the process TIA BernieH |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I hide or unhide zero value columns/rows USING A MACRO? | Excel Discussion (Misc queries) | |||
How do I open or close grouped columns/rows in a protected excel s | Excel Discussion (Misc queries) | |||
Rearranging aTable | New Users to Excel | |||
columns/rows | New Users to Excel | |||
Grouped Columns/Rows | Excel Worksheet Functions |