Dear green go through the attachment. it may help.
-- *****Great day,* *viper* On Fri, Aug 26, 2011 at 10:42 AM, NOORAIN ANSARI <noorain.ans...@gmail.com>wrote: > Please provide sample sheet. > > > On Fri, Aug 26, 2011 at 9:25 AM, GreenBriar > <impedimenta.st...@gmail.com>wrote: > >> I have a series of spreadsheets that have data in them that needs to >> be formatted into 3 columns instead of one column. >> >> The data in Row 1 needs to go in row 1, column 1 >> Row 2 needs to go in row 1, column 2 >> Row 3 = Row 1, Col 3 >> Row 4 = Row 2, Col 1 >> Row 5 = Row 2, Col 2 >> Row 6 = Row 2 Col 3 >> Row 7 = Row 3, Col 1, etc to the end of the file. >> >> What would be the macro that I need to use? I have been tasked with >> loading this data into a program but am unsure how to get it into the >> correct format. >> >> Any help would be greatly appreciated. >> >> -- >> >> ---------------------------------------------------------------------------------- >> Some important links for excel users: >> 1. Follow us on TWITTER for tips tricks and links : >> http://twitter.com/exceldailytip >> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 >> 3. Excel tutorials at http://www.excel-macros.blogspot.com >> 4. Learn VBA Macros at http://www.quickvba.blogspot.com >> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com >> >> To post to this group, send email to excel-macros@googlegroups.com >> >> <><><><><><><><><><><><><><><><><><><><><><> >> Like our page on facebook , Just follow below link >> http://www.facebook.com/discussexcel >> > > > > -- > Thanks & regards, > Noorain Ansari > *http://noorain-ansari.blogspot.com/*<http://noorain-ansari.blogspot.com/> > > -- > > ---------------------------------------------------------------------------------- > Some important links for excel users: > 1. Follow us on TWITTER for tips tricks and links : > http://twitter.com/exceldailytip > 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 > 3. Excel tutorials at http://www.excel-macros.blogspot.com > 4. Learn VBA Macros at http://www.quickvba.blogspot.com > 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com > > To post to this group, send email to excel-macros@googlegroups.com > > <><><><><><><><><><><><><><><><><><><><><><> > Like our page on facebook , Just follow below link > http://www.facebook.com/discussexcel > -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
sample.xls
Description: MS-Excel spreadsheet