Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Moving Data
Could any help on how to transpose 5 or 6 rows in one colum of data into 1 row of data, Ok that is the easy bit, I have that much data that I was wondering if I could Automate or set up some kind of template to do this as I paste the data into the program. The program the data is coming from does not allow me to export I have to manually cut and past. ThanKyou -- benn ------------------------------------------------------------------------ benn's Profile: http://www.excelforum.com/member.php...o&userid=29387 View this thread: http://www.excelforum.com/showthread...hreadid=490984 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Moving Data
Does this mean that the data is always on 5 rows on one file (and maybe 6 rows
on another)? Or does this mean that within one worksheet, the data is sometimes 5 rows and sometimes 6 rows? And is there a way to determine that grouping--maybe a blank row between groups??? benn wrote: Could any help on how to transpose 5 or 6 rows in one colum of data into 1 row of data, Ok that is the easy bit, I have that much data that I was wondering if I could Automate or set up some kind of template to do this as I paste the data into the program. The program the data is coming from does not allow me to export I have to manually cut and past. ThanKyou -- benn ------------------------------------------------------------------------ benn's Profile: http://www.excelforum.com/member.php...o&userid=29387 View this thread: http://www.excelforum.com/showthread...hreadid=490984 -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Charts not recognizing source data if original linked data is changed. | Charts and Charting in Excel | |||
Printing data validation scenarios | Excel Worksheet Functions | |||
Sort pages? | Excel Discussion (Misc queries) | |||
moving data in excel without deleting existing data | Excel Discussion (Misc queries) | |||
Running Data Table using an input that triggers DDE linked data | Excel Discussion (Misc queries) |