| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Move data from rows to columns in Excel
Hi! I have an Excel file in which all my data is in 1 column but on a lot of rows. I want to restructure it to more columns instead. Like this example: NOW I HAVE: Field 1A Header1 Field 2A Data1 Field 3A Header2 Field 4A Data2 Field 5A Header3 Field 6A Data3 I WANT IT LIKE THIS: Field 1A Header1 Field 2A Data1 Field 1B Header2 Field 2B Data2 Field 1C Header3 Field 2C Data3 Of course I have a lot of more data under each header, but it is number of data rows are ambigous. Is that possible by using some sort of script or macro? Regards Pich -- Pich ------------------------------------------------------------------------ Pich's Profile: http://www.excelforum.com/member.php...o&userid=29007 View this thread: http://www.excelforum.com/showthread...hreadid=487353 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| move data from columns to rows | Excel Worksheet Functions | |||
| How to move data from rows to columns | Excel Discussion (Misc queries) | |||
| Mass move data in rows to columns. | Excel Discussion (Misc queries) | |||
| how do i automatically move data from rows to columns? | Excel Discussion (Misc queries) | |||
| Move Data from rows to columns... | Excel Worksheet Functions | |||
Threaded Mode
