How to move segments of one long column to many columns?

**GuySmith** · 09-12-2009, 02:52 PM

I have a spreadsheet with only one column (A) with 3,500 rows of data. Each seven rows of data describes one product and there are 500 products.

How do I set up a macro to cut/copy each group of seven rows of column A and move/paste them to a new sheet so I have 7 rows by 500 columns, with each column containing data about each individual product?

Any help would be greatly appreciated.

TIA,

Guy
MS Excel for Mac 2008

**shg** · 09-12-2009, 03:51 PM

so I have 7 rows by 500 columns

Your profile says Excel 2003 and Excel 2008.

Excel 2003 has only 256 columns, and Excel 2008 doesn't support VBA, correct?

**GuySmith** · 09-12-2009, 04:18 PM

I have Excel 2008 (Part of Office:mac 2008).

And I have trouble spelling VBA, let alone know how to use it!

**shg** · 09-12-2009, 04:20 PM

You asked for a macro, right? That's VBA.

On the machine that has VBA, you don't have enough columns in Excel.

On the machine that has enough columns in Excel, you don't have VBA.

**GuySmith** · 09-12-2009, 04:37 PM

How embarrassing! I didn't know that Macros were VBA..

I do have Automator - but can't get a workflow to run right even though it does what I want it to when recording it.

I can also use 7 columns x 350 rows if that makes any difference.

Thanks again!

**protonLeah** · 09-12-2009, 04:42 PM

What are the seven attributes of the products? Is there a reason why the data can't be re-arranged in 500 rows by X columns; i.e., the product names in column one and the attributes in seven or so columns as in a regular table format?

**shg** · 09-12-2009, 04:52 PM

Please Login or Register  to view this content.

Adding a Macro to a Code Module
1. Copy the code from the post
2. Press Alt+F11 to open the Visual Basic Editor (VBE)
3. From the menu bar in the VBE window, do Insert > Module
4. Paste the code in the window that opens
5. Close the VBE to return to Excel

Do Alt+F8 from Excel and run DoIt.

**GuySmith** · 09-12-2009, 06:59 PM

You Rock!

Thank you very much for letting me borrow your brain cells - they work a heck of a lot better than mine

Guy

How to move segments of one long column to many columns?

LinkBack

Thread Tools

Rate This Thread

Display

How to move segments of one long column to many columns?

Re: How to move segments of one long column to many columns?

Re: How to move segments of one long column to many columns?

Re: How to move segments of one long column to many columns?

Re: How to move segments of one long column to many columns?

Re: How to move segments of one long column to many columns?

Re: How to move segments of one long column to many columns?

Re: How to move segments of one long column to many columns?

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions