Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old August 25th 05, 08:54 PM posted to microsoft.public.excel.programming
external usenet poster
 
First recorded activity by ExcelBanter: Aug 2005
Posts: 1
Default Converting column data to row data macro


There is a Macro for MS Excel out there that can take data in a column,
and as long as there is an empty cell between the "records" it will
take that column and post the data in row format. See example below.

The context of my problem is that I am scanning-in contact data from a
paper directory. I am using MS Office Document Scanning Add-on which
saves it as text directly to MS Word. Unfortunantly, it outputs to a
column.

I need that data formated for standardized CSV database formats into a
row.
I dont mind pasting this into Excel and adding an empty row in between
column "records" so that when the macro is applied each "6 fields" get
applied to a seperate row.

I know the macro exists, I just cant find in on the web anymore.



The Output I have is this:

Name
Address
City
Zip
Email

Name
Address
City
Zip
Email

I want is this:

Name, Address, City, Zip, Email
Name, Address, City, Zip, Email

Thanks!


--
unknowndevice
------------------------------------------------------------------------
unknowndevice's Profile: http://www.excelforum.com/member.php...o&userid=26646
View this thread: http://www.excelforum.com/showthread...hreadid=399230


  #2   Report Post  
Old August 25th 05, 09:35 PM posted to microsoft.public.excel.programming
external usenet poster
 
First recorded activity by ExcelBanter: Aug 2005
Posts: 1
Default Converting column data to row data macro


You could use the Transpose function in copy-paste, or the arra
function Transpose..

--
kralj
-----------------------------------------------------------------------
kraljb's Profile: http://www.excelforum.com/member.php...nfo&userid=995
View this thread: http://www.excelforum.com/showthread.php?threadid=39923



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Converting A String to a Column of Data carl Excel Worksheet Functions 2 May 19th 10 06:21 PM
Converting data from every second to a new column PRC Excel Discussion (Misc queries) 4 August 21st 08 01:04 AM
Excell functions for converting column data MegM Excel Worksheet Functions 7 April 15th 08 08:05 PM
Converting a matrix of data into a single column Hosley Excel Discussion (Misc queries) 6 April 19th 07 06:07 AM
Need help converting 1 column of data to several columns dhooie Excel Programming 5 February 29th 04 05:08 PM


All times are GMT +1. The time now is 03:01 AM.

Powered by vBulletin® Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.
Copyright 2004-2017 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017